<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="generator" content="ApiGen 2.6.1" />
	<meta name="robots" content="noindex" />

	<title>File drivers/firebird.php | Dibi 2.0.2 API documentation</title>

	<script type="text/javascript" src="resources/combined.js?3201557540"></script>
	<script type="text/javascript" src="elementlist.js?236042691"></script>
	<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?1321461267" />
	<link rel="search" type="application/opensearchdescription+xml" title="Dibi 2.0.2 API documentation" href="http://api.dibiphp.com/2.0/opensearch.xml" />

</head>

<body>
<div id="left">
	<div id="menu">

		<div id="groups">
			<h3>Packages</h3>
			<ul>
				<li class="active"><a href="package-dibi.html">dibi<span></span></a>
						<ul>
				<li class="active"><a href="package-dibi.drivers.html">drivers</a>
						</li>
				<li><a href="package-dibi.nette.html">nette</a>
						</li>
				<li><a href="package-dibi.reflection.html">reflection</a>
						</li>
							</ul></li>
				<li><a href="package-None.html">None</a>
						</li>
				<li><a href="package-PHP.html">PHP</a>
						</li>
			</ul>
		</div>

		<hr />


		<div id="elements">
			<h3>Classes</h3>
			<ul>
				<li class="active"><a href="DibiFirebirdDriver.html">DibiFirebirdDriver</a></li>
				<li><a href="DibiMsSql2005Driver.html">DibiMsSql2005Driver</a></li>
				<li><a href="DibiMsSqlDriver.html">DibiMsSqlDriver</a></li>
				<li><a href="DibiMySqlDriver.html">DibiMySqlDriver</a></li>
				<li><a href="DibiMySqliDriver.html">DibiMySqliDriver</a></li>
				<li><a href="DibiOdbcDriver.html">DibiOdbcDriver</a></li>
				<li><a href="DibiOracleDriver.html">DibiOracleDriver</a></li>
				<li><a href="DibiPdoDriver.html">DibiPdoDriver</a></li>
				<li><a href="DibiPostgreDriver.html">DibiPostgreDriver</a></li>
				<li><a href="DibiSqlite3Driver.html">DibiSqlite3Driver</a></li>
				<li><a href="DibiSqliteDriver.html">DibiSqliteDriver</a></li>
			</ul>



			<h3>Exceptions</h3>
			<ul>
				<li><a href="DibiProcedureException.html">DibiProcedureException</a></li>
			</ul>


		</div>
	</div>
</div>

<div id="splitter"></div>

<div id="right">
<div id="rightInner">
	<form action="http://www.google.com/cse" id="search">
		<input type="hidden" name="cx" value="011549293477758430224:x_apk4yrmjm" />
		<input type="hidden" name="ie" value="UTF-8" />
		<input type="hidden" name="more" value="api" />
		<input type="text" name="q" class="text" />
		<input type="submit" value="Search" />
	</form>

	<div id="navigation">
		<ul>
			<li>
				<a href="index.html" title="Overview"><span>Overview</span></a>
			</li>
			<li>
				<a href="package-dibi.drivers.html" title="Summary of dibi\drivers"><span>Package</span></a>
			</li>
			<li>
				<a href="DibiFirebirdDriver.html" title="Summary of DibiFirebirdDriver"><span>Class</span></a>
			</li>
		</ul>
		<ul>
			<li>
				<a href="tree.html" title="Tree view of classes, interfaces, traits and exceptions"><span>Tree</span></a>
			</li>
		</ul>
		<ul>
		</ul>
	</div>

<pre><code><a href="#1" id="1" class="l">  1: </a><span class="xlang">&lt;?php</span>
<a href="#2" id="2" class="l">  2: </a>
<a href="#3" id="3" class="l">  3: </a><span class="php-comment">/**
</span><a href="#4" id="4" class="l">  4: </a><span class="php-comment"> * This file is part of the &quot;dibi&quot; - smart database abstraction layer.
</span><a href="#5" id="5" class="l">  5: </a><span class="php-comment"> *
</span><a href="#6" id="6" class="l">  6: </a><span class="php-comment"> * Copyright (c) 2005 David Grudl (http://davidgrudl.com)
</span><a href="#7" id="7" class="l">  7: </a><span class="php-comment"> *
</span><a href="#8" id="8" class="l">  8: </a><span class="php-comment"> * For the full copyright and license information, please view
</span><a href="#9" id="9" class="l">  9: </a><span class="php-comment"> * the file license.txt that was distributed with this source code.
</span><a href="#10" id="10" class="l"> 10: </a><span class="php-comment"> */</span>
<a href="#11" id="11" class="l"> 11: </a>
<a href="#12" id="12" class="l"> 12: </a>
<a href="#13" id="13" class="l"> 13: </a><span class="php-comment">/**
</span><a href="#14" id="14" class="l"> 14: </a><span class="php-comment"> * The dibi driver for Firebird/InterBase database.
</span><a href="#15" id="15" class="l"> 15: </a><span class="php-comment"> *
</span><a href="#16" id="16" class="l"> 16: </a><span class="php-comment"> * Driver options:
</span><a href="#17" id="17" class="l"> 17: </a><span class="php-comment"> *   - database =&gt; the path to database file (server:/path/database.fdb)
</span><a href="#18" id="18" class="l"> 18: </a><span class="php-comment"> *   - username (or user)
</span><a href="#19" id="19" class="l"> 19: </a><span class="php-comment"> *   - password (or pass)
</span><a href="#20" id="20" class="l"> 20: </a><span class="php-comment"> *   - charset =&gt; character encoding to set
</span><a href="#21" id="21" class="l"> 21: </a><span class="php-comment"> *   - buffers (int) =&gt; buffers is the number of database buffers to allocate for the server-side cache. If 0 or omitted, server chooses its own default.
</span><a href="#22" id="22" class="l"> 22: </a><span class="php-comment"> *   - resource (resource) =&gt; existing connection resource
</span><a href="#23" id="23" class="l"> 23: </a><span class="php-comment"> *   - lazy, profiler, result, substitutes, ... =&gt; see DibiConnection options
</span><a href="#24" id="24" class="l"> 24: </a><span class="php-comment"> *
</span><a href="#25" id="25" class="l"> 25: </a><span class="php-comment"> * @author     Tomáš Kraina, Roman Sklenář
</span><a href="#26" id="26" class="l"> 26: </a><span class="php-comment"> * @package    dibi\drivers
</span><a href="#27" id="27" class="l"> 27: </a><span class="php-comment"> */</span>
<a href="#28" id="28" class="l"> 28: </a><span class="php-keyword1">class</span> DibiFirebirdDriver <span class="php-keyword1">extends</span> DibiObject <span class="php-keyword1">implements</span> IDibiDriver, IDibiResultDriver, IDibiReflector
<a href="#29" id="29" class="l"> 29: </a>{
<a href="#30" id="30" class="l"> 30: </a>    <span class="php-keyword1">const</span> ERROR_EXCEPTION_THROWN = -<span class="php-num">836</span>;
<a href="#31" id="31" class="l"> 31: </a>
<a href="#32" id="32" class="l"> 32: </a>    <span class="php-comment">/** @var resource  Connection resource */</span>
<a href="#33" id="33" class="l"> 33: </a>    <span class="php-keyword1">private</span> <span class="php-var">$connection</span>;
<a href="#34" id="34" class="l"> 34: </a>
<a href="#35" id="35" class="l"> 35: </a>    <span class="php-comment">/** @var resource  Resultset resource */</span>
<a href="#36" id="36" class="l"> 36: </a>    <span class="php-keyword1">private</span> <span class="php-var">$resultSet</span>;
<a href="#37" id="37" class="l"> 37: </a>
<a href="#38" id="38" class="l"> 38: </a>    <span class="php-comment">/** @var bool */</span>
<a href="#39" id="39" class="l"> 39: </a>    <span class="php-keyword1">private</span> <span class="php-var">$autoFree</span> = <span class="php-keyword1">TRUE</span>;
<a href="#40" id="40" class="l"> 40: </a>
<a href="#41" id="41" class="l"> 41: </a>    <span class="php-comment">/** @var resource  Resultset resource */</span>
<a href="#42" id="42" class="l"> 42: </a>    <span class="php-keyword1">private</span> <span class="php-var">$transaction</span>;
<a href="#43" id="43" class="l"> 43: </a>
<a href="#44" id="44" class="l"> 44: </a>    <span class="php-comment">/** @var bool */</span>
<a href="#45" id="45" class="l"> 45: </a>    <span class="php-keyword1">private</span> <span class="php-var">$inTransaction</span> = <span class="php-keyword1">FALSE</span>;
<a href="#46" id="46" class="l"> 46: </a>
<a href="#47" id="47" class="l"> 47: </a>
<a href="#48" id="48" class="l"> 48: </a>    <span class="php-comment">/**
</span><a href="#49" id="49" class="l"> 49: </a><span class="php-comment">     * @throws DibiNotSupportedException
</span><a href="#50" id="50" class="l"> 50: </a><span class="php-comment">     */</span>
<a href="#51" id="51" class="l"> 51: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> __construct()
<a href="#52" id="52" class="l"> 52: </a>    {
<a href="#53" id="53" class="l"> 53: </a>        <span class="php-keyword1">if</span> (!<span class="php-keyword2">extension_loaded</span>(<span class="php-quote">'interbase'</span>)) {
<a href="#54" id="54" class="l"> 54: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiNotSupportedException(<span class="php-quote">&quot;PHP extension 'interbase' is not loaded.&quot;</span>);
<a href="#55" id="55" class="l"> 55: </a>        }
<a href="#56" id="56" class="l"> 56: </a>    }
<a href="#57" id="57" class="l"> 57: </a>
<a href="#58" id="58" class="l"> 58: </a>
<a href="#59" id="59" class="l"> 59: </a>
<a href="#60" id="60" class="l"> 60: </a>    <span class="php-comment">/**
</span><a href="#61" id="61" class="l"> 61: </a><span class="php-comment">     * Connects to a database.
</span><a href="#62" id="62" class="l"> 62: </a><span class="php-comment">     * @return void
</span><a href="#63" id="63" class="l"> 63: </a><span class="php-comment">     * @throws DibiException
</span><a href="#64" id="64" class="l"> 64: </a><span class="php-comment">     */</span>
<a href="#65" id="65" class="l"> 65: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> connect(<span class="php-keyword1">array</span> &amp;<span class="php-var">$config</span>)
<a href="#66" id="66" class="l"> 66: </a>    {
<a href="#67" id="67" class="l"> 67: </a>        DibiConnection::alias(<span class="php-var">$config</span>, <span class="php-quote">'database'</span>, <span class="php-quote">'db'</span>);
<a href="#68" id="68" class="l"> 68: </a>
<a href="#69" id="69" class="l"> 69: </a>        <span class="php-keyword1">if</span> (<span class="php-keyword1">isset</span>(<span class="php-var">$config</span>[<span class="php-quote">'resource'</span>])) {
<a href="#70" id="70" class="l"> 70: </a>            <span class="php-var">$this</span>-&gt;connection = <span class="php-var">$config</span>[<span class="php-quote">'resource'</span>];
<a href="#71" id="71" class="l"> 71: </a>
<a href="#72" id="72" class="l"> 72: </a>        } <span class="php-keyword1">else</span> {
<a href="#73" id="73" class="l"> 73: </a>            <span class="php-comment">// default values</span>
<a href="#74" id="74" class="l"> 74: </a>            <span class="php-keyword1">if</span> (!<span class="php-keyword1">isset</span>(<span class="php-var">$config</span>[<span class="php-quote">'username'</span>])) <span class="php-var">$config</span>[<span class="php-quote">'username'</span>] = <span class="php-keyword2">ini_get</span>(<span class="php-quote">'ibase.default_password'</span>);
<a href="#75" id="75" class="l"> 75: </a>            <span class="php-keyword1">if</span> (!<span class="php-keyword1">isset</span>(<span class="php-var">$config</span>[<span class="php-quote">'password'</span>])) <span class="php-var">$config</span>[<span class="php-quote">'password'</span>] = <span class="php-keyword2">ini_get</span>(<span class="php-quote">'ibase.default_user'</span>);
<a href="#76" id="76" class="l"> 76: </a>            <span class="php-keyword1">if</span> (!<span class="php-keyword1">isset</span>(<span class="php-var">$config</span>[<span class="php-quote">'database'</span>])) <span class="php-var">$config</span>[<span class="php-quote">'database'</span>] = <span class="php-keyword2">ini_get</span>(<span class="php-quote">'ibase.default_db'</span>);
<a href="#77" id="77" class="l"> 77: </a>            <span class="php-keyword1">if</span> (!<span class="php-keyword1">isset</span>(<span class="php-var">$config</span>[<span class="php-quote">'charset'</span>])) <span class="php-var">$config</span>[<span class="php-quote">'charset'</span>] = <span class="php-keyword2">ini_get</span>(<span class="php-quote">'ibase.default_charset'</span>);
<a href="#78" id="78" class="l"> 78: </a>            <span class="php-keyword1">if</span> (!<span class="php-keyword1">isset</span>(<span class="php-var">$config</span>[<span class="php-quote">'buffers'</span>])) <span class="php-var">$config</span>[<span class="php-quote">'buffers'</span>] = <span class="php-num">0</span>;
<a href="#79" id="79" class="l"> 79: </a>
<a href="#80" id="80" class="l"> 80: </a>            DibiDriverException::tryError();
<a href="#81" id="81" class="l"> 81: </a>            <span class="php-keyword1">if</span> (<span class="php-keyword1">empty</span>(<span class="php-var">$config</span>[<span class="php-quote">'persistent'</span>])) {
<a href="#82" id="82" class="l"> 82: </a>                <span class="php-var">$this</span>-&gt;connection = <span class="php-keyword2">ibase_connect</span>(<span class="php-var">$config</span>[<span class="php-quote">'database'</span>], <span class="php-var">$config</span>[<span class="php-quote">'username'</span>], <span class="php-var">$config</span>[<span class="php-quote">'password'</span>], <span class="php-var">$config</span>[<span class="php-quote">'charset'</span>], <span class="php-var">$config</span>[<span class="php-quote">'buffers'</span>]); <span class="php-comment">// intentionally @</span>
<a href="#83" id="83" class="l"> 83: </a>            } <span class="php-keyword1">else</span> {
<a href="#84" id="84" class="l"> 84: </a>                <span class="php-var">$this</span>-&gt;connection = <span class="php-keyword2">ibase_pconnect</span>(<span class="php-var">$config</span>[<span class="php-quote">'database'</span>], <span class="php-var">$config</span>[<span class="php-quote">'username'</span>], <span class="php-var">$config</span>[<span class="php-quote">'password'</span>], <span class="php-var">$config</span>[<span class="php-quote">'charset'</span>], <span class="php-var">$config</span>[<span class="php-quote">'buffers'</span>]); <span class="php-comment">// intentionally @</span>
<a href="#85" id="85" class="l"> 85: </a>            }
<a href="#86" id="86" class="l"> 86: </a>            <span class="php-keyword1">if</span> (DibiDriverException::catchError(<span class="php-var">$msg</span>)) {
<a href="#87" id="87" class="l"> 87: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiDriverException(<span class="php-var">$msg</span>, <span class="php-keyword2">ibase_errcode</span>());
<a href="#88" id="88" class="l"> 88: </a>            }
<a href="#89" id="89" class="l"> 89: </a>
<a href="#90" id="90" class="l"> 90: </a>            <span class="php-keyword1">if</span> (!<span class="php-keyword2">is_resource</span>(<span class="php-var">$this</span>-&gt;connection)) {
<a href="#91" id="91" class="l"> 91: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiDriverException(<span class="php-keyword2">ibase_errmsg</span>(), <span class="php-keyword2">ibase_errcode</span>());
<a href="#92" id="92" class="l"> 92: </a>            }
<a href="#93" id="93" class="l"> 93: </a>        }
<a href="#94" id="94" class="l"> 94: </a>
<a href="#95" id="95" class="l"> 95: </a>    }
<a href="#96" id="96" class="l"> 96: </a>
<a href="#97" id="97" class="l"> 97: </a>
<a href="#98" id="98" class="l"> 98: </a>
<a href="#99" id="99" class="l"> 99: </a>    <span class="php-comment">/**
</span><a href="#100" id="100" class="l">100: </a><span class="php-comment">     * Disconnects from a database.
</span><a href="#101" id="101" class="l">101: </a><span class="php-comment">     * @return void
</span><a href="#102" id="102" class="l">102: </a><span class="php-comment">     */</span>
<a href="#103" id="103" class="l">103: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> disconnect()
<a href="#104" id="104" class="l">104: </a>    {
<a href="#105" id="105" class="l">105: </a>        <span class="php-keyword2">ibase_close</span>(<span class="php-var">$this</span>-&gt;connection);
<a href="#106" id="106" class="l">106: </a>    }
<a href="#107" id="107" class="l">107: </a>
<a href="#108" id="108" class="l">108: </a>
<a href="#109" id="109" class="l">109: </a>
<a href="#110" id="110" class="l">110: </a>    <span class="php-comment">/**
</span><a href="#111" id="111" class="l">111: </a><span class="php-comment">     * Executes the SQL query.
</span><a href="#112" id="112" class="l">112: </a><span class="php-comment">     * @param  string      SQL statement.
</span><a href="#113" id="113" class="l">113: </a><span class="php-comment">     * @return IDibiResultDriver|NULL
</span><a href="#114" id="114" class="l">114: </a><span class="php-comment">     * @throws DibiDriverException|DibiException
</span><a href="#115" id="115" class="l">115: </a><span class="php-comment">     */</span>
<a href="#116" id="116" class="l">116: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> query(<span class="php-var">$sql</span>)
<a href="#117" id="117" class="l">117: </a>    {
<a href="#118" id="118" class="l">118: </a>        DibiDriverException::tryError();
<a href="#119" id="119" class="l">119: </a>        <span class="php-var">$resource</span> = <span class="php-var">$this</span>-&gt;inTransaction ? <span class="php-var">$this</span>-&gt;transaction : <span class="php-var">$this</span>-&gt;connection;
<a href="#120" id="120" class="l">120: </a>        <span class="php-var">$res</span> = <span class="php-keyword2">ibase_query</span>(<span class="php-var">$resource</span>, <span class="php-var">$sql</span>);
<a href="#121" id="121" class="l">121: </a>
<a href="#122" id="122" class="l">122: </a>        <span class="php-keyword1">if</span> (DibiDriverException::catchError(<span class="php-var">$msg</span>)) {
<a href="#123" id="123" class="l">123: </a>            <span class="php-keyword1">if</span> (<span class="php-keyword2">ibase_errcode</span>() == self::ERROR_EXCEPTION_THROWN) {
<a href="#124" id="124" class="l">124: </a>                <span class="php-keyword2">preg_match</span>(<span class="php-quote">'/exception (\d+) (\w+) (.*)/i'</span>, <span class="php-keyword2">ibase_errmsg</span>(), <span class="php-var">$match</span>);
<a href="#125" id="125" class="l">125: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiProcedureException(<span class="php-var">$match</span>[<span class="php-num">3</span>], <span class="php-var">$match</span>[<span class="php-num">1</span>], <span class="php-var">$match</span>[<span class="php-num">2</span>], dibi::<span class="php-var">$sql</span>);
<a href="#126" id="126" class="l">126: </a>
<a href="#127" id="127" class="l">127: </a>            } <span class="php-keyword1">else</span> {
<a href="#128" id="128" class="l">128: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiDriverException(<span class="php-keyword2">ibase_errmsg</span>(), <span class="php-keyword2">ibase_errcode</span>(), dibi::<span class="php-var">$sql</span>);
<a href="#129" id="129" class="l">129: </a>            }
<a href="#130" id="130" class="l">130: </a>        }
<a href="#131" id="131" class="l">131: </a>
<a href="#132" id="132" class="l">132: </a>        <span class="php-keyword1">if</span> (<span class="php-var">$res</span> === <span class="php-keyword1">FALSE</span>) {
<a href="#133" id="133" class="l">133: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiDriverException(<span class="php-keyword2">ibase_errmsg</span>(), <span class="php-keyword2">ibase_errcode</span>(), <span class="php-var">$sql</span>);
<a href="#134" id="134" class="l">134: </a>
<a href="#135" id="135" class="l">135: </a>        } <span class="php-keyword1">elseif</span> (<span class="php-keyword2">is_resource</span>(<span class="php-var">$res</span>)) {
<a href="#136" id="136" class="l">136: </a>            <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;createResultDriver(<span class="php-var">$res</span>);
<a href="#137" id="137" class="l">137: </a>        }
<a href="#138" id="138" class="l">138: </a>    }
<a href="#139" id="139" class="l">139: </a>
<a href="#140" id="140" class="l">140: </a>
<a href="#141" id="141" class="l">141: </a>
<a href="#142" id="142" class="l">142: </a>    <span class="php-comment">/**
</span><a href="#143" id="143" class="l">143: </a><span class="php-comment">     * Gets the number of affected rows by the last INSERT, UPDATE or DELETE query.
</span><a href="#144" id="144" class="l">144: </a><span class="php-comment">     * @return int|FALSE  number of rows or FALSE on error
</span><a href="#145" id="145" class="l">145: </a><span class="php-comment">     */</span>
<a href="#146" id="146" class="l">146: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getAffectedRows()
<a href="#147" id="147" class="l">147: </a>    {
<a href="#148" id="148" class="l">148: </a>        <span class="php-keyword1">return</span> <span class="php-keyword2">ibase_affected_rows</span>(<span class="php-var">$this</span>-&gt;connection);
<a href="#149" id="149" class="l">149: </a>    }
<a href="#150" id="150" class="l">150: </a>
<a href="#151" id="151" class="l">151: </a>
<a href="#152" id="152" class="l">152: </a>
<a href="#153" id="153" class="l">153: </a>    <span class="php-comment">/**
</span><a href="#154" id="154" class="l">154: </a><span class="php-comment">     * Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.
</span><a href="#155" id="155" class="l">155: </a><span class="php-comment">     * @param  string     generator name
</span><a href="#156" id="156" class="l">156: </a><span class="php-comment">     * @return int|FALSE  int on success or FALSE on failure
</span><a href="#157" id="157" class="l">157: </a><span class="php-comment">     */</span>
<a href="#158" id="158" class="l">158: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getInsertId(<span class="php-var">$sequence</span>)
<a href="#159" id="159" class="l">159: </a>    {
<a href="#160" id="160" class="l">160: </a>        <span class="php-keyword1">return</span> <span class="php-keyword2">ibase_gen_id</span>(<span class="php-var">$sequence</span>, <span class="php-num">0</span>, <span class="php-var">$this</span>-&gt;connection);
<a href="#161" id="161" class="l">161: </a>    }
<a href="#162" id="162" class="l">162: </a>
<a href="#163" id="163" class="l">163: </a>
<a href="#164" id="164" class="l">164: </a>
<a href="#165" id="165" class="l">165: </a>    <span class="php-comment">/**
</span><a href="#166" id="166" class="l">166: </a><span class="php-comment">     * Begins a transaction (if supported).
</span><a href="#167" id="167" class="l">167: </a><span class="php-comment">     * @param  string  optional savepoint name
</span><a href="#168" id="168" class="l">168: </a><span class="php-comment">     * @return void
</span><a href="#169" id="169" class="l">169: </a><span class="php-comment">     * @throws DibiDriverException
</span><a href="#170" id="170" class="l">170: </a><span class="php-comment">     */</span>
<a href="#171" id="171" class="l">171: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> begin(<span class="php-var">$savepoint</span> = <span class="php-keyword1">NULL</span>)
<a href="#172" id="172" class="l">172: </a>    {
<a href="#173" id="173" class="l">173: </a>        <span class="php-keyword1">if</span> (<span class="php-var">$savepoint</span> !== <span class="php-keyword1">NULL</span>) {
<a href="#174" id="174" class="l">174: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiNotSupportedException(<span class="php-quote">'Savepoints are not supported in Firebird/Interbase.'</span>);
<a href="#175" id="175" class="l">175: </a>        }
<a href="#176" id="176" class="l">176: </a>        <span class="php-var">$this</span>-&gt;transaction = <span class="php-keyword2">ibase_trans</span>(<span class="php-var">$this</span>-&gt;resource);
<a href="#177" id="177" class="l">177: </a>        <span class="php-var">$this</span>-&gt;inTransaction = <span class="php-keyword1">TRUE</span>;
<a href="#178" id="178" class="l">178: </a>    }
<a href="#179" id="179" class="l">179: </a>
<a href="#180" id="180" class="l">180: </a>
<a href="#181" id="181" class="l">181: </a>
<a href="#182" id="182" class="l">182: </a>    <span class="php-comment">/**
</span><a href="#183" id="183" class="l">183: </a><span class="php-comment">     * Commits statements in a transaction.
</span><a href="#184" id="184" class="l">184: </a><span class="php-comment">     * @param  string  optional savepoint name
</span><a href="#185" id="185" class="l">185: </a><span class="php-comment">     * @return void
</span><a href="#186" id="186" class="l">186: </a><span class="php-comment">     * @throws DibiDriverException
</span><a href="#187" id="187" class="l">187: </a><span class="php-comment">     */</span>
<a href="#188" id="188" class="l">188: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> commit(<span class="php-var">$savepoint</span> = <span class="php-keyword1">NULL</span>)
<a href="#189" id="189" class="l">189: </a>    {
<a href="#190" id="190" class="l">190: </a>        <span class="php-keyword1">if</span> (<span class="php-var">$savepoint</span> !== <span class="php-keyword1">NULL</span>) {
<a href="#191" id="191" class="l">191: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiNotSupportedException(<span class="php-quote">'Savepoints are not supported in Firebird/Interbase.'</span>);
<a href="#192" id="192" class="l">192: </a>        }
<a href="#193" id="193" class="l">193: </a>
<a href="#194" id="194" class="l">194: </a>        <span class="php-keyword1">if</span> (!<span class="php-keyword2">ibase_commit</span>(<span class="php-var">$this</span>-&gt;transaction)) {
<a href="#195" id="195" class="l">195: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiDriverException(<span class="php-quote">'Unable to handle operation - failure when commiting transaction.'</span>);
<a href="#196" id="196" class="l">196: </a>        }
<a href="#197" id="197" class="l">197: </a>
<a href="#198" id="198" class="l">198: </a>        <span class="php-var">$this</span>-&gt;inTransaction = <span class="php-keyword1">FALSE</span>;
<a href="#199" id="199" class="l">199: </a>    }
<a href="#200" id="200" class="l">200: </a>
<a href="#201" id="201" class="l">201: </a>
<a href="#202" id="202" class="l">202: </a>
<a href="#203" id="203" class="l">203: </a>    <span class="php-comment">/**
</span><a href="#204" id="204" class="l">204: </a><span class="php-comment">     * Rollback changes in a transaction.
</span><a href="#205" id="205" class="l">205: </a><span class="php-comment">     * @param  string  optional savepoint name
</span><a href="#206" id="206" class="l">206: </a><span class="php-comment">     * @return void
</span><a href="#207" id="207" class="l">207: </a><span class="php-comment">     * @throws DibiDriverException
</span><a href="#208" id="208" class="l">208: </a><span class="php-comment">     */</span>
<a href="#209" id="209" class="l">209: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> rollback(<span class="php-var">$savepoint</span> = <span class="php-keyword1">NULL</span>)
<a href="#210" id="210" class="l">210: </a>    {
<a href="#211" id="211" class="l">211: </a>        <span class="php-keyword1">if</span> (<span class="php-var">$savepoint</span> !== <span class="php-keyword1">NULL</span>) {
<a href="#212" id="212" class="l">212: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiNotSupportedException(<span class="php-quote">'Savepoints are not supported in Firebird/Interbase.'</span>);
<a href="#213" id="213" class="l">213: </a>        }
<a href="#214" id="214" class="l">214: </a>
<a href="#215" id="215" class="l">215: </a>        <span class="php-keyword1">if</span> (!<span class="php-keyword2">ibase_rollback</span>(<span class="php-var">$this</span>-&gt;transaction)) {
<a href="#216" id="216" class="l">216: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiDriverException(<span class="php-quote">'Unable to handle operation - failure when rolbacking transaction.'</span>);
<a href="#217" id="217" class="l">217: </a>        }
<a href="#218" id="218" class="l">218: </a>
<a href="#219" id="219" class="l">219: </a>        <span class="php-var">$this</span>-&gt;inTransaction = <span class="php-keyword1">FALSE</span>;
<a href="#220" id="220" class="l">220: </a>    }
<a href="#221" id="221" class="l">221: </a>
<a href="#222" id="222" class="l">222: </a>
<a href="#223" id="223" class="l">223: </a>
<a href="#224" id="224" class="l">224: </a>    <span class="php-comment">/**
</span><a href="#225" id="225" class="l">225: </a><span class="php-comment">     * Is in transaction?
</span><a href="#226" id="226" class="l">226: </a><span class="php-comment">     * @return bool
</span><a href="#227" id="227" class="l">227: </a><span class="php-comment">     */</span>
<a href="#228" id="228" class="l">228: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> inTransaction()
<a href="#229" id="229" class="l">229: </a>    {
<a href="#230" id="230" class="l">230: </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;inTransaction;
<a href="#231" id="231" class="l">231: </a>    }
<a href="#232" id="232" class="l">232: </a>
<a href="#233" id="233" class="l">233: </a>
<a href="#234" id="234" class="l">234: </a>
<a href="#235" id="235" class="l">235: </a>    <span class="php-comment">/**
</span><a href="#236" id="236" class="l">236: </a><span class="php-comment">     * Returns the connection resource.
</span><a href="#237" id="237" class="l">237: </a><span class="php-comment">     * @return resource
</span><a href="#238" id="238" class="l">238: </a><span class="php-comment">     */</span>
<a href="#239" id="239" class="l">239: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getResource()
<a href="#240" id="240" class="l">240: </a>    {
<a href="#241" id="241" class="l">241: </a>        <span class="php-keyword1">return</span> <span class="php-keyword2">is_resource</span>(<span class="php-var">$this</span>-&gt;connection) ? <span class="php-var">$this</span>-&gt;connection : <span class="php-keyword1">NULL</span>;
<a href="#242" id="242" class="l">242: </a>    }
<a href="#243" id="243" class="l">243: </a>
<a href="#244" id="244" class="l">244: </a>
<a href="#245" id="245" class="l">245: </a>
<a href="#246" id="246" class="l">246: </a>    <span class="php-comment">/**
</span><a href="#247" id="247" class="l">247: </a><span class="php-comment">     * Returns the connection reflector.
</span><a href="#248" id="248" class="l">248: </a><span class="php-comment">     * @return IDibiReflector
</span><a href="#249" id="249" class="l">249: </a><span class="php-comment">     */</span>
<a href="#250" id="250" class="l">250: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getReflector()
<a href="#251" id="251" class="l">251: </a>    {
<a href="#252" id="252" class="l">252: </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>;
<a href="#253" id="253" class="l">253: </a>    }
<a href="#254" id="254" class="l">254: </a>
<a href="#255" id="255" class="l">255: </a>
<a href="#256" id="256" class="l">256: </a>
<a href="#257" id="257" class="l">257: </a>    <span class="php-comment">/**
</span><a href="#258" id="258" class="l">258: </a><span class="php-comment">     * Result set driver factory.
</span><a href="#259" id="259" class="l">259: </a><span class="php-comment">     * @param  resource
</span><a href="#260" id="260" class="l">260: </a><span class="php-comment">     * @return IDibiResultDriver
</span><a href="#261" id="261" class="l">261: </a><span class="php-comment">     */</span>
<a href="#262" id="262" class="l">262: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> createResultDriver(<span class="php-var">$resource</span>)
<a href="#263" id="263" class="l">263: </a>    {
<a href="#264" id="264" class="l">264: </a>        <span class="php-var">$res</span> = <span class="php-keyword1">clone</span> <span class="php-var">$this</span>;
<a href="#265" id="265" class="l">265: </a>        <span class="php-var">$res</span>-&gt;resultSet = <span class="php-var">$resource</span>;
<a href="#266" id="266" class="l">266: </a>        <span class="php-keyword1">return</span> <span class="php-var">$res</span>;
<a href="#267" id="267" class="l">267: </a>    }
<a href="#268" id="268" class="l">268: </a>
<a href="#269" id="269" class="l">269: </a>
<a href="#270" id="270" class="l">270: </a>
<a href="#271" id="271" class="l">271: </a>    <span class="php-comment">/********************* SQL ********************/</span>
<a href="#272" id="272" class="l">272: </a>
<a href="#273" id="273" class="l">273: </a>
<a href="#274" id="274" class="l">274: </a>
<a href="#275" id="275" class="l">275: </a>    <span class="php-comment">/**
</span><a href="#276" id="276" class="l">276: </a><span class="php-comment">     * Encodes data for use in a SQL statement.
</span><a href="#277" id="277" class="l">277: </a><span class="php-comment">     * @param  mixed     value
</span><a href="#278" id="278" class="l">278: </a><span class="php-comment">     * @param  string    type (dibi::TEXT, dibi::BOOL, ...)
</span><a href="#279" id="279" class="l">279: </a><span class="php-comment">     * @return string    encoded value
</span><a href="#280" id="280" class="l">280: </a><span class="php-comment">     * @throws InvalidArgumentException
</span><a href="#281" id="281" class="l">281: </a><span class="php-comment">     */</span>
<a href="#282" id="282" class="l">282: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> escape(<span class="php-var">$value</span>, <span class="php-var">$type</span>)
<a href="#283" id="283" class="l">283: </a>    {
<a href="#284" id="284" class="l">284: </a>        <span class="php-keyword1">switch</span> (<span class="php-var">$type</span>) {
<a href="#285" id="285" class="l">285: </a>        <span class="php-keyword1">case</span> dibi::TEXT:
<a href="#286" id="286" class="l">286: </a>        <span class="php-keyword1">case</span> dibi::BINARY:
<a href="#287" id="287" class="l">287: </a>            <span class="php-keyword1">return</span> <span class="php-quote">&quot;'&quot;</span> . <span class="php-keyword2">str_replace</span>(<span class="php-quote">&quot;'&quot;</span>, <span class="php-quote">&quot;''&quot;</span>, <span class="php-var">$value</span>) . <span class="php-quote">&quot;'&quot;</span>;
<a href="#288" id="288" class="l">288: </a>
<a href="#289" id="289" class="l">289: </a>        <span class="php-keyword1">case</span> dibi::IDENTIFIER:
<a href="#290" id="290" class="l">290: </a>            <span class="php-keyword1">return</span> <span class="php-var">$value</span>;
<a href="#291" id="291" class="l">291: </a>
<a href="#292" id="292" class="l">292: </a>        <span class="php-keyword1">case</span> dibi::BOOL:
<a href="#293" id="293" class="l">293: </a>            <span class="php-keyword1">return</span> <span class="php-var">$value</span> ? <span class="php-num">1</span> : <span class="php-num">0</span>;
<a href="#294" id="294" class="l">294: </a>
<a href="#295" id="295" class="l">295: </a>        <span class="php-keyword1">case</span> dibi::<span class="php-keyword2">DATE</span>:
<a href="#296" id="296" class="l">296: </a>            <span class="php-keyword1">return</span> <span class="php-var">$value</span> <span class="php-keyword1">instanceof</span> DateTime ? <span class="php-var">$value</span>-&gt;format(<span class="php-quote">&quot;'Y-m-d'&quot;</span>) : <span class="php-keyword2">date</span>(<span class="php-quote">&quot;'Y-m-d'&quot;</span>, <span class="php-var">$value</span>);
<a href="#297" id="297" class="l">297: </a>
<a href="#298" id="298" class="l">298: </a>        <span class="php-keyword1">case</span> dibi::DATETIME:
<a href="#299" id="299" class="l">299: </a>            <span class="php-keyword1">return</span> <span class="php-var">$value</span> <span class="php-keyword1">instanceof</span> DateTime ? <span class="php-var">$value</span>-&gt;format(<span class="php-quote">&quot;'Y-m-d H:i:s'&quot;</span>) : <span class="php-keyword2">date</span>(<span class="php-quote">&quot;'Y-m-d H:i:s'&quot;</span>, <span class="php-var">$value</span>);
<a href="#300" id="300" class="l">300: </a>
<a href="#301" id="301" class="l">301: </a>        <span class="php-keyword1">default</span>:
<a href="#302" id="302" class="l">302: </a>            <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> InvalidArgumentException(<span class="php-quote">'Unsupported type.'</span>);
<a href="#303" id="303" class="l">303: </a>        }
<a href="#304" id="304" class="l">304: </a>    }
<a href="#305" id="305" class="l">305: </a>
<a href="#306" id="306" class="l">306: </a>
<a href="#307" id="307" class="l">307: </a>
<a href="#308" id="308" class="l">308: </a>    <span class="php-comment">/**
</span><a href="#309" id="309" class="l">309: </a><span class="php-comment">     * Encodes string for use in a LIKE statement.
</span><a href="#310" id="310" class="l">310: </a><span class="php-comment">     * @param  string
</span><a href="#311" id="311" class="l">311: </a><span class="php-comment">     * @param  int
</span><a href="#312" id="312" class="l">312: </a><span class="php-comment">     * @return string
</span><a href="#313" id="313" class="l">313: </a><span class="php-comment">     */</span>
<a href="#314" id="314" class="l">314: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> escapeLike(<span class="php-var">$value</span>, <span class="php-var">$pos</span>)
<a href="#315" id="315" class="l">315: </a>    {
<a href="#316" id="316" class="l">316: </a>        <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiNotImplementedException;
<a href="#317" id="317" class="l">317: </a>    }
<a href="#318" id="318" class="l">318: </a>
<a href="#319" id="319" class="l">319: </a>
<a href="#320" id="320" class="l">320: </a>
<a href="#321" id="321" class="l">321: </a>    <span class="php-comment">/**
</span><a href="#322" id="322" class="l">322: </a><span class="php-comment">     * Decodes data from result set.
</span><a href="#323" id="323" class="l">323: </a><span class="php-comment">     * @param  string    value
</span><a href="#324" id="324" class="l">324: </a><span class="php-comment">     * @param  string    type (dibi::BINARY)
</span><a href="#325" id="325" class="l">325: </a><span class="php-comment">     * @return string    decoded value
</span><a href="#326" id="326" class="l">326: </a><span class="php-comment">     * @throws InvalidArgumentException
</span><a href="#327" id="327" class="l">327: </a><span class="php-comment">     */</span>
<a href="#328" id="328" class="l">328: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> unescape(<span class="php-var">$value</span>, <span class="php-var">$type</span>)
<a href="#329" id="329" class="l">329: </a>    {
<a href="#330" id="330" class="l">330: </a>        <span class="php-keyword1">if</span> (<span class="php-var">$type</span> === dibi::BINARY) {
<a href="#331" id="331" class="l">331: </a>            <span class="php-keyword1">return</span> <span class="php-var">$value</span>;
<a href="#332" id="332" class="l">332: </a>        }
<a href="#333" id="333" class="l">333: </a>        <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> InvalidArgumentException(<span class="php-quote">'Unsupported type.'</span>);
<a href="#334" id="334" class="l">334: </a>    }
<a href="#335" id="335" class="l">335: </a>
<a href="#336" id="336" class="l">336: </a>
<a href="#337" id="337" class="l">337: </a>
<a href="#338" id="338" class="l">338: </a>    <span class="php-comment">/**
</span><a href="#339" id="339" class="l">339: </a><span class="php-comment">     * Injects LIMIT/OFFSET to the SQL query.
</span><a href="#340" id="340" class="l">340: </a><span class="php-comment">     * @param  string &amp;$sql  The SQL query that will be modified.
</span><a href="#341" id="341" class="l">341: </a><span class="php-comment">     * @param  int $limit
</span><a href="#342" id="342" class="l">342: </a><span class="php-comment">     * @param  int $offset
</span><a href="#343" id="343" class="l">343: </a><span class="php-comment">     * @return void
</span><a href="#344" id="344" class="l">344: </a><span class="php-comment">     */</span>
<a href="#345" id="345" class="l">345: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> applyLimit(&amp;<span class="php-var">$sql</span>, <span class="php-var">$limit</span>, <span class="php-var">$offset</span>)
<a href="#346" id="346" class="l">346: </a>    {
<a href="#347" id="347" class="l">347: </a>        <span class="php-keyword1">if</span> (<span class="php-var">$limit</span> &lt; <span class="php-num">0</span> &amp;&amp; <span class="php-var">$offset</span> &lt; <span class="php-num">1</span>) <span class="php-keyword1">return</span>;
<a href="#348" id="348" class="l">348: </a>
<a href="#349" id="349" class="l">349: </a>        <span class="php-comment">// see http://scott.yang.id.au/2004/01/limit-in-select-statements-in-firebird/</span>
<a href="#350" id="350" class="l">350: </a>        <span class="php-var">$sql</span> = <span class="php-quote">'SELECT FIRST '</span> . (int) <span class="php-var">$limit</span> . (<span class="php-var">$offset</span> &gt; <span class="php-num">0</span> ? <span class="php-quote">' SKIP '</span> . (int) <span class="php-var">$offset</span> : <span class="php-quote">''</span>) . <span class="php-quote">' * FROM ('</span> . <span class="php-var">$sql</span> . <span class="php-quote">')'</span>;
<a href="#351" id="351" class="l">351: </a>    }
<a href="#352" id="352" class="l">352: </a>
<a href="#353" id="353" class="l">353: </a>
<a href="#354" id="354" class="l">354: </a>
<a href="#355" id="355" class="l">355: </a>    <span class="php-comment">/********************* result set ********************/</span>
<a href="#356" id="356" class="l">356: </a>
<a href="#357" id="357" class="l">357: </a>
<a href="#358" id="358" class="l">358: </a>
<a href="#359" id="359" class="l">359: </a>    <span class="php-comment">/**
</span><a href="#360" id="360" class="l">360: </a><span class="php-comment">     * Automatically frees the resources allocated for this result set.
</span><a href="#361" id="361" class="l">361: </a><span class="php-comment">     * @return void
</span><a href="#362" id="362" class="l">362: </a><span class="php-comment">     */</span>
<a href="#363" id="363" class="l">363: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> __destruct()
<a href="#364" id="364" class="l">364: </a>    {
<a href="#365" id="365" class="l">365: </a>        <span class="php-var">$this</span>-&gt;autoFree &amp;&amp; <span class="php-var">$this</span>-&gt;getResultResource() &amp;&amp; <span class="php-var">$this</span>-&gt;free();
<a href="#366" id="366" class="l">366: </a>    }
<a href="#367" id="367" class="l">367: </a>
<a href="#368" id="368" class="l">368: </a>
<a href="#369" id="369" class="l">369: </a>
<a href="#370" id="370" class="l">370: </a>    <span class="php-comment">/**
</span><a href="#371" id="371" class="l">371: </a><span class="php-comment">     * Returns the number of rows in a result set.
</span><a href="#372" id="372" class="l">372: </a><span class="php-comment">     * @return int
</span><a href="#373" id="373" class="l">373: </a><span class="php-comment">     */</span>
<a href="#374" id="374" class="l">374: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getRowCount()
<a href="#375" id="375" class="l">375: </a>    {
<a href="#376" id="376" class="l">376: </a>        <span class="php-keyword1">return</span> <span class="php-keyword2">ibase_num_fields</span>(<span class="php-var">$this</span>-&gt;resultSet);
<a href="#377" id="377" class="l">377: </a>    }
<a href="#378" id="378" class="l">378: </a>
<a href="#379" id="379" class="l">379: </a>
<a href="#380" id="380" class="l">380: </a>
<a href="#381" id="381" class="l">381: </a>    <span class="php-comment">/**
</span><a href="#382" id="382" class="l">382: </a><span class="php-comment">     * Fetches the row at current position and moves the internal cursor to the next position.
</span><a href="#383" id="383" class="l">383: </a><span class="php-comment">     * @param  bool     TRUE for associative array, FALSE for numeric
</span><a href="#384" id="384" class="l">384: </a><span class="php-comment">     * @return array    array on success, nonarray if no next record
</span><a href="#385" id="385" class="l">385: </a><span class="php-comment">     */</span>
<a href="#386" id="386" class="l">386: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> fetch(<span class="php-var">$assoc</span>)
<a href="#387" id="387" class="l">387: </a>    {
<a href="#388" id="388" class="l">388: </a>        DibiDriverException::tryError();
<a href="#389" id="389" class="l">389: </a>        <span class="php-var">$result</span> = <span class="php-var">$assoc</span> ? <span class="php-keyword2">ibase_fetch_assoc</span>(<span class="php-var">$this</span>-&gt;resultSet, IBASE_TEXT) : <span class="php-keyword2">ibase_fetch_row</span>(<span class="php-var">$this</span>-&gt;resultSet, IBASE_TEXT); <span class="php-comment">// intentionally @</span>
<a href="#390" id="390" class="l">390: </a>
<a href="#391" id="391" class="l">391: </a>        <span class="php-keyword1">if</span> (DibiDriverException::catchError(<span class="php-var">$msg</span>)) {
<a href="#392" id="392" class="l">392: </a>            <span class="php-keyword1">if</span> (<span class="php-keyword2">ibase_errcode</span>() == self::ERROR_EXCEPTION_THROWN) {
<a href="#393" id="393" class="l">393: </a>                <span class="php-keyword2">preg_match</span>(<span class="php-quote">'/exception (\d+) (\w+) (.*)/i'</span>, <span class="php-keyword2">ibase_errmsg</span>(), <span class="php-var">$match</span>);
<a href="#394" id="394" class="l">394: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiProcedureException(<span class="php-var">$match</span>[<span class="php-num">3</span>], <span class="php-var">$match</span>[<span class="php-num">1</span>], <span class="php-var">$match</span>[<span class="php-num">2</span>], dibi::<span class="php-var">$sql</span>);
<a href="#395" id="395" class="l">395: </a>
<a href="#396" id="396" class="l">396: </a>            } <span class="php-keyword1">else</span> {
<a href="#397" id="397" class="l">397: </a>                <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiDriverException(<span class="php-var">$msg</span>, <span class="php-keyword2">ibase_errcode</span>(), dibi::<span class="php-var">$sql</span>);
<a href="#398" id="398" class="l">398: </a>            }
<a href="#399" id="399" class="l">399: </a>        }
<a href="#400" id="400" class="l">400: </a>
<a href="#401" id="401" class="l">401: </a>        <span class="php-keyword1">return</span> <span class="php-var">$result</span>;
<a href="#402" id="402" class="l">402: </a>    }
<a href="#403" id="403" class="l">403: </a>
<a href="#404" id="404" class="l">404: </a>
<a href="#405" id="405" class="l">405: </a>
<a href="#406" id="406" class="l">406: </a>    <span class="php-comment">/**
</span><a href="#407" id="407" class="l">407: </a><span class="php-comment">     * Moves cursor position without fetching row.
</span><a href="#408" id="408" class="l">408: </a><span class="php-comment">     * @param  int      the 0-based cursor pos to seek to
</span><a href="#409" id="409" class="l">409: </a><span class="php-comment">     * @return boolean  TRUE on success, FALSE if unable to seek to specified record
</span><a href="#410" id="410" class="l">410: </a><span class="php-comment">     * @throws DibiException
</span><a href="#411" id="411" class="l">411: </a><span class="php-comment">     */</span>
<a href="#412" id="412" class="l">412: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> seek(<span class="php-var">$row</span>)
<a href="#413" id="413" class="l">413: </a>    {
<a href="#414" id="414" class="l">414: </a>        <span class="php-keyword1">throw</span> <span class="php-keyword1">new</span> DibiNotSupportedException(<span class="php-quote">&quot;Firebird/Interbase do not support seek in result set.&quot;</span>);
<a href="#415" id="415" class="l">415: </a>    }
<a href="#416" id="416" class="l">416: </a>
<a href="#417" id="417" class="l">417: </a>
<a href="#418" id="418" class="l">418: </a>
<a href="#419" id="419" class="l">419: </a>    <span class="php-comment">/**
</span><a href="#420" id="420" class="l">420: </a><span class="php-comment">     * Frees the resources allocated for this result set.
</span><a href="#421" id="421" class="l">421: </a><span class="php-comment">     * @return void
</span><a href="#422" id="422" class="l">422: </a><span class="php-comment">     */</span>
<a href="#423" id="423" class="l">423: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> free()
<a href="#424" id="424" class="l">424: </a>    {
<a href="#425" id="425" class="l">425: </a>        <span class="php-keyword2">ibase_free_result</span>(<span class="php-var">$this</span>-&gt;resultSet);
<a href="#426" id="426" class="l">426: </a>        <span class="php-var">$this</span>-&gt;resultSet = <span class="php-keyword1">NULL</span>;
<a href="#427" id="427" class="l">427: </a>    }
<a href="#428" id="428" class="l">428: </a>
<a href="#429" id="429" class="l">429: </a>
<a href="#430" id="430" class="l">430: </a>
<a href="#431" id="431" class="l">431: </a>    <span class="php-comment">/**
</span><a href="#432" id="432" class="l">432: </a><span class="php-comment">     * Returns the result set resource.
</span><a href="#433" id="433" class="l">433: </a><span class="php-comment">     * @return mysqli_result
</span><a href="#434" id="434" class="l">434: </a><span class="php-comment">     */</span>
<a href="#435" id="435" class="l">435: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getResultResource()
<a href="#436" id="436" class="l">436: </a>    {
<a href="#437" id="437" class="l">437: </a>        <span class="php-var">$this</span>-&gt;autoFree = <span class="php-keyword1">FALSE</span>;
<a href="#438" id="438" class="l">438: </a>        <span class="php-keyword1">return</span> <span class="php-keyword2">is_resource</span>(<span class="php-var">$this</span>-&gt;resultSet) ? <span class="php-var">$this</span>-&gt;resultSet : <span class="php-keyword1">NULL</span>;
<a href="#439" id="439" class="l">439: </a>    }
<a href="#440" id="440" class="l">440: </a>
<a href="#441" id="441" class="l">441: </a>
<a href="#442" id="442" class="l">442: </a>
<a href="#443" id="443" class="l">443: </a>    <span class="php-comment">/**
</span><a href="#444" id="444" class="l">444: </a><span class="php-comment">     * Returns metadata for all columns in a result set.
</span><a href="#445" id="445" class="l">445: </a><span class="php-comment">     * @return array
</span><a href="#446" id="446" class="l">446: </a><span class="php-comment">     */</span>
<a href="#447" id="447" class="l">447: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getResultColumns()
<a href="#448" id="448" class="l">448: </a>    {
<a href="#449" id="449" class="l">449: </a>        <span class="php-var">$count</span> = <span class="php-keyword2">ibase_num_fields</span>(<span class="php-var">$this</span>-&gt;resultSet);
<a href="#450" id="450" class="l">450: </a>        <span class="php-var">$columns</span> = <span class="php-keyword1">array</span>();
<a href="#451" id="451" class="l">451: </a>        <span class="php-keyword1">for</span> (<span class="php-var">$i</span> = <span class="php-num">0</span>; <span class="php-var">$i</span> &lt; <span class="php-var">$count</span>; <span class="php-var">$i</span>++) {
<a href="#452" id="452" class="l">452: </a>            <span class="php-var">$row</span> = (<span class="php-keyword1">array</span>) <span class="php-keyword2">ibase_field_info</span>(<span class="php-var">$this</span>-&gt;resultSet, <span class="php-var">$i</span>);
<a href="#453" id="453" class="l">453: </a>            <span class="php-var">$columns</span>[] = <span class="php-keyword1">array</span>(
<a href="#454" id="454" class="l">454: </a>                <span class="php-quote">'name'</span> =&gt; <span class="php-var">$row</span>[<span class="php-quote">'name'</span>],
<a href="#455" id="455" class="l">455: </a>                <span class="php-quote">'fullname'</span> =&gt; <span class="php-var">$row</span>[<span class="php-quote">'name'</span>],
<a href="#456" id="456" class="l">456: </a>                <span class="php-quote">'table'</span> =&gt; <span class="php-var">$row</span>[<span class="php-quote">'relation'</span>],
<a href="#457" id="457" class="l">457: </a>                <span class="php-quote">'nativetype'</span> =&gt; <span class="php-var">$row</span>[<span class="php-quote">'type'</span>],
<a href="#458" id="458" class="l">458: </a>            );
<a href="#459" id="459" class="l">459: </a>        }
<a href="#460" id="460" class="l">460: </a>        <span class="php-keyword1">return</span> <span class="php-var">$columns</span>;
<a href="#461" id="461" class="l">461: </a>    }
<a href="#462" id="462" class="l">462: </a>
<a href="#463" id="463" class="l">463: </a>
<a href="#464" id="464" class="l">464: </a>
<a href="#465" id="465" class="l">465: </a>    <span class="php-comment">/********************* IDibiReflector ********************/</span>
<a href="#466" id="466" class="l">466: </a>
<a href="#467" id="467" class="l">467: </a>
<a href="#468" id="468" class="l">468: </a>
<a href="#469" id="469" class="l">469: </a>    <span class="php-comment">/**
</span><a href="#470" id="470" class="l">470: </a><span class="php-comment">     * Returns list of tables.
</span><a href="#471" id="471" class="l">471: </a><span class="php-comment">     * @return array
</span><a href="#472" id="472" class="l">472: </a><span class="php-comment">     */</span>
<a href="#473" id="473" class="l">473: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getTables()
<a href="#474" id="474" class="l">474: </a>    {
<a href="#475" id="475" class="l">475: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-quote">&quot;
</span><a href="#476" id="476" class="l">476: </a><span class="php-quote">            SELECT TRIM(RDB\</span><span class="php-var">$RELATION_NAME</span><span class="php-quote">),
</span><a href="#477" id="477" class="l">477: </a><span class="php-quote">                CASE RDB\</span><span class="php-var">$VIEW_BLR</span><span class="php-quote"> WHEN NULL THEN 'TRUE' ELSE 'FALSE' END
</span><a href="#478" id="478" class="l">478: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$RELATIONS</span><span class="php-quote">
</span><a href="#479" id="479" class="l">479: </a><span class="php-quote">            WHERE RDB\</span><span class="php-var">$SYSTEM_FLAG</span><span class="php-quote"> = 0;&quot;</span>
<a href="#480" id="480" class="l">480: </a>        );
<a href="#481" id="481" class="l">481: </a>        <span class="php-var">$tables</span> = <span class="php-keyword1">array</span>();
<a href="#482" id="482" class="l">482: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">FALSE</span>)) {
<a href="#483" id="483" class="l">483: </a>            <span class="php-var">$tables</span>[] = <span class="php-keyword1">array</span>(
<a href="#484" id="484" class="l">484: </a>                <span class="php-quote">'name'</span> =&gt; <span class="php-var">$row</span>[<span class="php-num">0</span>],
<a href="#485" id="485" class="l">485: </a>                <span class="php-quote">'view'</span> =&gt; <span class="php-var">$row</span>[<span class="php-num">1</span>] === <span class="php-quote">'TRUE'</span>,
<a href="#486" id="486" class="l">486: </a>            );
<a href="#487" id="487" class="l">487: </a>        }
<a href="#488" id="488" class="l">488: </a>        <span class="php-keyword1">return</span> <span class="php-var">$tables</span>;
<a href="#489" id="489" class="l">489: </a>    }
<a href="#490" id="490" class="l">490: </a>
<a href="#491" id="491" class="l">491: </a>
<a href="#492" id="492" class="l">492: </a>
<a href="#493" id="493" class="l">493: </a>    <span class="php-comment">/**
</span><a href="#494" id="494" class="l">494: </a><span class="php-comment">     * Returns metadata for all columns in a table.
</span><a href="#495" id="495" class="l">495: </a><span class="php-comment">     * @param  string
</span><a href="#496" id="496" class="l">496: </a><span class="php-comment">     * @return array
</span><a href="#497" id="497" class="l">497: </a><span class="php-comment">     */</span>
<a href="#498" id="498" class="l">498: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getColumns(<span class="php-var">$table</span>)
<a href="#499" id="499" class="l">499: </a>    {
<a href="#500" id="500" class="l">500: </a>        <span class="php-var">$table</span> = <span class="php-keyword2">strtoupper</span>(<span class="php-var">$table</span>);
<a href="#501" id="501" class="l">501: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-quote">&quot;
</span><a href="#502" id="502" class="l">502: </a><span class="php-quote">            SELECT TRIM(r.RDB\</span><span class="php-var">$FIELD_NAME</span><span class="php-quote">) AS FIELD_NAME,
</span><a href="#503" id="503" class="l">503: </a><span class="php-quote">                CASE f.RDB\</span><span class="php-var">$FIELD_TYPE</span><span class="php-quote">
</span><a href="#504" id="504" class="l">504: </a><span class="php-quote">                    WHEN 261 THEN 'BLOB'
</span><a href="#505" id="505" class="l">505: </a><span class="php-quote">                    WHEN 14 THEN 'CHAR'
</span><a href="#506" id="506" class="l">506: </a><span class="php-quote">                    WHEN 40 THEN 'CSTRING'
</span><a href="#507" id="507" class="l">507: </a><span class="php-quote">                    WHEN 11 THEN 'D_FLOAT'
</span><a href="#508" id="508" class="l">508: </a><span class="php-quote">                    WHEN 27 THEN 'DOUBLE'
</span><a href="#509" id="509" class="l">509: </a><span class="php-quote">                    WHEN 10 THEN 'FLOAT'
</span><a href="#510" id="510" class="l">510: </a><span class="php-quote">                    WHEN 16 THEN 'INT64'
</span><a href="#511" id="511" class="l">511: </a><span class="php-quote">                    WHEN 8 THEN 'INTEGER'
</span><a href="#512" id="512" class="l">512: </a><span class="php-quote">                    WHEN 9 THEN 'QUAD'
</span><a href="#513" id="513" class="l">513: </a><span class="php-quote">                    WHEN 7 THEN 'SMALLINT'
</span><a href="#514" id="514" class="l">514: </a><span class="php-quote">                    WHEN 12 THEN 'DATE'
</span><a href="#515" id="515" class="l">515: </a><span class="php-quote">                    WHEN 13 THEN 'TIME'
</span><a href="#516" id="516" class="l">516: </a><span class="php-quote">                    WHEN 35 THEN 'TIMESTAMP'
</span><a href="#517" id="517" class="l">517: </a><span class="php-quote">                    WHEN 37 THEN 'VARCHAR'
</span><a href="#518" id="518" class="l">518: </a><span class="php-quote">                    ELSE 'UNKNOWN'
</span><a href="#519" id="519" class="l">519: </a><span class="php-quote">                END AS FIELD_TYPE,
</span><a href="#520" id="520" class="l">520: </a><span class="php-quote">                f.RDB\</span><span class="php-var">$FIELD_LENGTH</span><span class="php-quote"> AS FIELD_LENGTH,
</span><a href="#521" id="521" class="l">521: </a><span class="php-quote">                r.RDB\</span><span class="php-var">$DEFAULT_VALUE</span><span class="php-quote"> AS DEFAULT_VALUE,
</span><a href="#522" id="522" class="l">522: </a><span class="php-quote">                CASE r.RDB\</span><span class="php-var">$NULL_FLAG</span><span class="php-quote">
</span><a href="#523" id="523" class="l">523: </a><span class="php-quote">                    WHEN 1 THEN 'FALSE' ELSE 'TRUE'
</span><a href="#524" id="524" class="l">524: </a><span class="php-quote">                END AS NULLABLE
</span><a href="#525" id="525" class="l">525: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$RELATION_FIELDS</span><span class="php-quote"> r
</span><a href="#526" id="526" class="l">526: </a><span class="php-quote">                LEFT JOIN RDB\</span><span class="php-var">$FIELDS</span><span class="php-quote"> f ON r.RDB\</span><span class="php-var">$FIELD_SOURCE</span><span class="php-quote"> = f.RDB\</span><span class="php-var">$FIELD_NAME</span><span class="php-quote">
</span><a href="#527" id="527" class="l">527: </a><span class="php-quote">            WHERE r.RDB\</span><span class="php-var">$RELATION_NAME</span><span class="php-quote"> = '</span><span class="php-var">$table</span><span class="php-quote">'
</span><a href="#528" id="528" class="l">528: </a><span class="php-quote">            ORDER BY r.RDB\</span><span class="php-var">$FIELD_POSITION</span><span class="php-quote">;&quot;</span>
<a href="#529" id="529" class="l">529: </a>
<a href="#530" id="530" class="l">530: </a>        );
<a href="#531" id="531" class="l">531: </a>        <span class="php-var">$columns</span> = <span class="php-keyword1">array</span>();
<a href="#532" id="532" class="l">532: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">TRUE</span>)) {
<a href="#533" id="533" class="l">533: </a>            <span class="php-var">$key</span> = <span class="php-var">$row</span>[<span class="php-quote">'FIELD_NAME'</span>];
<a href="#534" id="534" class="l">534: </a>            <span class="php-var">$columns</span>[<span class="php-var">$key</span>] = <span class="php-keyword1">array</span>(
<a href="#535" id="535" class="l">535: </a>                <span class="php-quote">'name'</span> =&gt; <span class="php-var">$key</span>,
<a href="#536" id="536" class="l">536: </a>                <span class="php-quote">'table'</span> =&gt; <span class="php-var">$table</span>,
<a href="#537" id="537" class="l">537: </a>                <span class="php-quote">'nativetype'</span> =&gt; <span class="php-keyword2">trim</span>(<span class="php-var">$row</span>[<span class="php-quote">'FIELD_TYPE'</span>]),
<a href="#538" id="538" class="l">538: </a>                <span class="php-quote">'size'</span> =&gt; <span class="php-var">$row</span>[<span class="php-quote">'FIELD_LENGTH'</span>],
<a href="#539" id="539" class="l">539: </a>                <span class="php-quote">'nullable'</span> =&gt; <span class="php-var">$row</span>[<span class="php-quote">'NULLABLE'</span>] === <span class="php-quote">'TRUE'</span>,
<a href="#540" id="540" class="l">540: </a>                <span class="php-quote">'default'</span> =&gt; <span class="php-var">$row</span>[<span class="php-quote">'DEFAULT_VALUE'</span>],
<a href="#541" id="541" class="l">541: </a>                <span class="php-quote">'autoincrement'</span> =&gt; <span class="php-keyword1">FALSE</span>,
<a href="#542" id="542" class="l">542: </a>            );
<a href="#543" id="543" class="l">543: </a>        }
<a href="#544" id="544" class="l">544: </a>        <span class="php-keyword1">return</span> <span class="php-var">$columns</span>;
<a href="#545" id="545" class="l">545: </a>    }
<a href="#546" id="546" class="l">546: </a>
<a href="#547" id="547" class="l">547: </a>
<a href="#548" id="548" class="l">548: </a>
<a href="#549" id="549" class="l">549: </a>    <span class="php-comment">/**
</span><a href="#550" id="550" class="l">550: </a><span class="php-comment">     * Returns metadata for all indexes in a table (the constraints are included).
</span><a href="#551" id="551" class="l">551: </a><span class="php-comment">     * @param  string
</span><a href="#552" id="552" class="l">552: </a><span class="php-comment">     * @return array
</span><a href="#553" id="553" class="l">553: </a><span class="php-comment">     */</span>
<a href="#554" id="554" class="l">554: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getIndexes(<span class="php-var">$table</span>)
<a href="#555" id="555" class="l">555: </a>    {
<a href="#556" id="556" class="l">556: </a>        <span class="php-var">$table</span> = <span class="php-keyword2">strtoupper</span>(<span class="php-var">$table</span>);
<a href="#557" id="557" class="l">557: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-quote">&quot;
</span><a href="#558" id="558" class="l">558: </a><span class="php-quote">            SELECT TRIM(s.RDB\</span><span class="php-var">$INDEX_NAME</span><span class="php-quote">) AS INDEX_NAME,
</span><a href="#559" id="559" class="l">559: </a><span class="php-quote">                TRIM(s.RDB\</span><span class="php-var">$FIELD_NAME</span><span class="php-quote">) AS FIELD_NAME,
</span><a href="#560" id="560" class="l">560: </a><span class="php-quote">                i.RDB\</span><span class="php-var">$UNIQUE_FLAG</span><span class="php-quote"> AS UNIQUE_FLAG,
</span><a href="#561" id="561" class="l">561: </a><span class="php-quote">                i.RDB\</span><span class="php-var">$FOREIGN_KEY</span><span class="php-quote"> AS FOREIGN_KEY,
</span><a href="#562" id="562" class="l">562: </a><span class="php-quote">                TRIM(r.RDB\</span><span class="php-var">$CONSTRAINT_TYPE</span><span class="php-quote">) AS CONSTRAINT_TYPE,
</span><a href="#563" id="563" class="l">563: </a><span class="php-quote">                s.RDB\</span><span class="php-var">$FIELD_POSITION</span><span class="php-quote"> AS FIELD_POSITION
</span><a href="#564" id="564" class="l">564: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$INDEX_SEGMENTS</span><span class="php-quote"> s
</span><a href="#565" id="565" class="l">565: </a><span class="php-quote">                LEFT JOIN RDB\</span><span class="php-var">$INDICES</span><span class="php-quote"> i ON i.RDB\</span><span class="php-var">$INDEX_NAME</span><span class="php-quote"> = s.RDB\</span><span class="php-var">$INDEX_NAME</span><span class="php-quote">
</span><a href="#566" id="566" class="l">566: </a><span class="php-quote">                LEFT JOIN RDB\</span><span class="php-var">$RELATION_CONSTRAINTS</span><span class="php-quote"> r ON r.RDB\</span><span class="php-var">$INDEX_NAME</span><span class="php-quote"> = s.RDB\</span><span class="php-var">$INDEX_NAME</span><span class="php-quote">
</span><a href="#567" id="567" class="l">567: </a><span class="php-quote">            WHERE UPPER(i.RDB\</span><span class="php-var">$RELATION_NAME</span><span class="php-quote">) = '</span><span class="php-var">$table</span><span class="php-quote">'
</span><a href="#568" id="568" class="l">568: </a><span class="php-quote">            ORDER BY s.RDB\</span><span class="php-var">$FIELD_POSITION</span><span class="php-quote">&quot;</span>
<a href="#569" id="569" class="l">569: </a>        );
<a href="#570" id="570" class="l">570: </a>        <span class="php-var">$indexes</span> = <span class="php-keyword1">array</span>();
<a href="#571" id="571" class="l">571: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">TRUE</span>)) {
<a href="#572" id="572" class="l">572: </a>            <span class="php-var">$key</span> = <span class="php-var">$row</span>[<span class="php-quote">'INDEX_NAME'</span>];
<a href="#573" id="573" class="l">573: </a>            <span class="php-var">$indexes</span>[<span class="php-var">$key</span>][<span class="php-quote">'name'</span>] = <span class="php-var">$key</span>;
<a href="#574" id="574" class="l">574: </a>            <span class="php-var">$indexes</span>[<span class="php-var">$key</span>][<span class="php-quote">'unique'</span>] = <span class="php-var">$row</span>[<span class="php-quote">'UNIQUE_FLAG'</span>] === <span class="php-num">1</span>;
<a href="#575" id="575" class="l">575: </a>            <span class="php-var">$indexes</span>[<span class="php-var">$key</span>][<span class="php-quote">'primary'</span>] = <span class="php-var">$row</span>[<span class="php-quote">'CONSTRAINT_TYPE'</span>] === <span class="php-quote">'PRIMARY KEY'</span>;
<a href="#576" id="576" class="l">576: </a>            <span class="php-var">$indexes</span>[<span class="php-var">$key</span>][<span class="php-quote">'table'</span>] = <span class="php-var">$table</span>;
<a href="#577" id="577" class="l">577: </a>            <span class="php-var">$indexes</span>[<span class="php-var">$key</span>][<span class="php-quote">'columns'</span>][<span class="php-var">$row</span>[<span class="php-quote">'FIELD_POSITION'</span>]] = <span class="php-var">$row</span>[<span class="php-quote">'FIELD_NAME'</span>];
<a href="#578" id="578" class="l">578: </a>        }
<a href="#579" id="579" class="l">579: </a>        <span class="php-keyword1">return</span> <span class="php-var">$indexes</span>;
<a href="#580" id="580" class="l">580: </a>    }
<a href="#581" id="581" class="l">581: </a>
<a href="#582" id="582" class="l">582: </a>
<a href="#583" id="583" class="l">583: </a>
<a href="#584" id="584" class="l">584: </a>    <span class="php-comment">/**
</span><a href="#585" id="585" class="l">585: </a><span class="php-comment">     * Returns metadata for all foreign keys in a table.
</span><a href="#586" id="586" class="l">586: </a><span class="php-comment">     * @param  string
</span><a href="#587" id="587" class="l">587: </a><span class="php-comment">     * @return array
</span><a href="#588" id="588" class="l">588: </a><span class="php-comment">     */</span>
<a href="#589" id="589" class="l">589: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getForeignKeys(<span class="php-var">$table</span>)
<a href="#590" id="590" class="l">590: </a>    {
<a href="#591" id="591" class="l">591: </a>        <span class="php-var">$table</span> = <span class="php-keyword2">strtoupper</span>(<span class="php-var">$table</span>);
<a href="#592" id="592" class="l">592: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-quote">&quot;
</span><a href="#593" id="593" class="l">593: </a><span class="php-quote">            SELECT TRIM(s.RDB\</span><span class="php-var">$INDEX_NAME</span><span class="php-quote">) AS INDEX_NAME,
</span><a href="#594" id="594" class="l">594: </a><span class="php-quote">                TRIM(s.RDB\</span><span class="php-var">$FIELD_NAME</span><span class="php-quote">) AS FIELD_NAME,
</span><a href="#595" id="595" class="l">595: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$INDEX_SEGMENTS</span><span class="php-quote"> s
</span><a href="#596" id="596" class="l">596: </a><span class="php-quote">                LEFT JOIN RDB\</span><span class="php-var">$RELATION_CONSTRAINTS</span><span class="php-quote"> r ON r.RDB\</span><span class="php-var">$INDEX_NAME</span><span class="php-quote"> = s.RDB\</span><span class="php-var">$INDEX_NAME</span><span class="php-quote">
</span><a href="#597" id="597" class="l">597: </a><span class="php-quote">            WHERE UPPER(i.RDB\</span><span class="php-var">$RELATION_NAME</span><span class="php-quote">) = '</span><span class="php-var">$table</span><span class="php-quote">'
</span><a href="#598" id="598" class="l">598: </a><span class="php-quote">                AND r.RDB\</span><span class="php-var">$CONSTRAINT_TYPE</span><span class="php-quote"> = 'FOREIGN KEY'
</span><a href="#599" id="599" class="l">599: </a><span class="php-quote">            ORDER BY s.RDB\</span><span class="php-var">$FIELD_POSITION</span><span class="php-quote">&quot;</span>
<a href="#600" id="600" class="l">600: </a>        );
<a href="#601" id="601" class="l">601: </a>        <span class="php-var">$keys</span> = <span class="php-keyword1">array</span>();
<a href="#602" id="602" class="l">602: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">TRUE</span>)) {
<a href="#603" id="603" class="l">603: </a>            <span class="php-var">$key</span> = <span class="php-var">$row</span>[<span class="php-quote">'INDEX_NAME'</span>];
<a href="#604" id="604" class="l">604: </a>            <span class="php-var">$keys</span>[<span class="php-var">$key</span>] = <span class="php-keyword1">array</span>(
<a href="#605" id="605" class="l">605: </a>                <span class="php-quote">'name'</span> =&gt; <span class="php-var">$key</span>,
<a href="#606" id="606" class="l">606: </a>                <span class="php-quote">'column'</span> =&gt; <span class="php-var">$row</span>[<span class="php-quote">'FIELD_NAME'</span>],
<a href="#607" id="607" class="l">607: </a>                <span class="php-quote">'table'</span> =&gt; <span class="php-var">$table</span>,
<a href="#608" id="608" class="l">608: </a>            );
<a href="#609" id="609" class="l">609: </a>        }
<a href="#610" id="610" class="l">610: </a>        <span class="php-keyword1">return</span> <span class="php-var">$keys</span>;
<a href="#611" id="611" class="l">611: </a>    }
<a href="#612" id="612" class="l">612: </a>
<a href="#613" id="613" class="l">613: </a>
<a href="#614" id="614" class="l">614: </a>
<a href="#615" id="615" class="l">615: </a>    <span class="php-comment">/**
</span><a href="#616" id="616" class="l">616: </a><span class="php-comment">     * Returns list of indices in given table (the constraints are not listed).
</span><a href="#617" id="617" class="l">617: </a><span class="php-comment">     * @param  string
</span><a href="#618" id="618" class="l">618: </a><span class="php-comment">     * @return array
</span><a href="#619" id="619" class="l">619: </a><span class="php-comment">     */</span>
<a href="#620" id="620" class="l">620: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getIndices(<span class="php-var">$table</span>)
<a href="#621" id="621" class="l">621: </a>    {
<a href="#622" id="622" class="l">622: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-quote">&quot;
</span><a href="#623" id="623" class="l">623: </a><span class="php-quote">            SELECT TRIM(RDB\</span><span class="php-var">$INDEX_NAME</span><span class="php-quote">)
</span><a href="#624" id="624" class="l">624: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$INDICES</span><span class="php-quote">
</span><a href="#625" id="625" class="l">625: </a><span class="php-quote">            WHERE RDB\</span><span class="php-var">$RELATION_NAME</span><span class="php-quote"> = UPPER('</span><span class="php-var">$table</span><span class="php-quote">')
</span><a href="#626" id="626" class="l">626: </a><span class="php-quote">                AND RDB\</span><span class="php-var">$UNIQUE_FLAG</span><span class="php-quote"> IS NULL
</span><a href="#627" id="627" class="l">627: </a><span class="php-quote">                AND RDB\</span><span class="php-var">$FOREIGN_KEY</span><span class="php-quote"> IS NULL;&quot;</span>
<a href="#628" id="628" class="l">628: </a>        );
<a href="#629" id="629" class="l">629: </a>        <span class="php-var">$indices</span> = <span class="php-keyword1">array</span>();
<a href="#630" id="630" class="l">630: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">FALSE</span>)) {
<a href="#631" id="631" class="l">631: </a>            <span class="php-var">$indices</span>[] = <span class="php-var">$row</span>[<span class="php-num">0</span>];
<a href="#632" id="632" class="l">632: </a>        }
<a href="#633" id="633" class="l">633: </a>        <span class="php-keyword1">return</span> <span class="php-var">$indices</span>;
<a href="#634" id="634" class="l">634: </a>    }
<a href="#635" id="635" class="l">635: </a>
<a href="#636" id="636" class="l">636: </a>
<a href="#637" id="637" class="l">637: </a>
<a href="#638" id="638" class="l">638: </a>    <span class="php-comment">/**
</span><a href="#639" id="639" class="l">639: </a><span class="php-comment">     * Returns list of constraints in given table.
</span><a href="#640" id="640" class="l">640: </a><span class="php-comment">     * @param  string
</span><a href="#641" id="641" class="l">641: </a><span class="php-comment">     * @return array
</span><a href="#642" id="642" class="l">642: </a><span class="php-comment">     */</span>
<a href="#643" id="643" class="l">643: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getConstraints(<span class="php-var">$table</span>)
<a href="#644" id="644" class="l">644: </a>    {
<a href="#645" id="645" class="l">645: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-quote">&quot;
</span><a href="#646" id="646" class="l">646: </a><span class="php-quote">            SELECT TRIM(RDB\</span><span class="php-var">$INDEX_NAME</span><span class="php-quote">)
</span><a href="#647" id="647" class="l">647: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$INDICES</span><span class="php-quote">
</span><a href="#648" id="648" class="l">648: </a><span class="php-quote">            WHERE RDB\</span><span class="php-var">$RELATION_NAME</span><span class="php-quote"> = UPPER('</span><span class="php-var">$table</span><span class="php-quote">')
</span><a href="#649" id="649" class="l">649: </a><span class="php-quote">                AND (
</span><a href="#650" id="650" class="l">650: </a><span class="php-quote">                    RDB\</span><span class="php-var">$UNIQUE_FLAG</span><span class="php-quote"> IS NOT NULL
</span><a href="#651" id="651" class="l">651: </a><span class="php-quote">                    OR RDB\</span><span class="php-var">$FOREIGN_KEY</span><span class="php-quote"> IS NOT NULL
</span><a href="#652" id="652" class="l">652: </a><span class="php-quote">            );&quot;</span>
<a href="#653" id="653" class="l">653: </a>        );
<a href="#654" id="654" class="l">654: </a>        <span class="php-var">$constraints</span> = <span class="php-keyword1">array</span>();
<a href="#655" id="655" class="l">655: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">FALSE</span>)) {
<a href="#656" id="656" class="l">656: </a>            <span class="php-var">$constraints</span>[] = <span class="php-var">$row</span>[<span class="php-num">0</span>];
<a href="#657" id="657" class="l">657: </a>        }
<a href="#658" id="658" class="l">658: </a>        <span class="php-keyword1">return</span> <span class="php-var">$constraints</span>;
<a href="#659" id="659" class="l">659: </a>    }
<a href="#660" id="660" class="l">660: </a>
<a href="#661" id="661" class="l">661: </a>
<a href="#662" id="662" class="l">662: </a>
<a href="#663" id="663" class="l">663: </a>    <span class="php-comment">/**
</span><a href="#664" id="664" class="l">664: </a><span class="php-comment">     * Returns metadata for all triggers in a table or database.
</span><a href="#665" id="665" class="l">665: </a><span class="php-comment">     * (Only if user has permissions on ALTER TABLE, INSERT/UPDATE/DELETE record in table)
</span><a href="#666" id="666" class="l">666: </a><span class="php-comment">     * @param  string
</span><a href="#667" id="667" class="l">667: </a><span class="php-comment">     * @param  string
</span><a href="#668" id="668" class="l">668: </a><span class="php-comment">     * @return array
</span><a href="#669" id="669" class="l">669: </a><span class="php-comment">     */</span>
<a href="#670" id="670" class="l">670: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getTriggersMeta(<span class="php-var">$table</span> = <span class="php-keyword1">NULL</span>)
<a href="#671" id="671" class="l">671: </a>    {
<a href="#672" id="672" class="l">672: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-quote">&quot;
</span><a href="#673" id="673" class="l">673: </a><span class="php-quote">            SELECT TRIM(RDB\</span><span class="php-var">$TRIGGER_NAME</span><span class="php-quote">) AS TRIGGER_NAME,
</span><a href="#674" id="674" class="l">674: </a><span class="php-quote">                TRIM(RDB\</span><span class="php-var">$RELATION_NAME</span><span class="php-quote">) AS TABLE_NAME,
</span><a href="#675" id="675" class="l">675: </a><span class="php-quote">                CASE RDB\</span><span class="php-var">$TRIGGER_TYPE</span><span class="php-quote">
</span><a href="#676" id="676" class="l">676: </a><span class="php-quote">                    WHEN 1 THEN 'BEFORE'
</span><a href="#677" id="677" class="l">677: </a><span class="php-quote">                    WHEN 2 THEN 'AFTER'
</span><a href="#678" id="678" class="l">678: </a><span class="php-quote">                    WHEN 3 THEN 'BEFORE'
</span><a href="#679" id="679" class="l">679: </a><span class="php-quote">                    WHEN 4 THEN 'AFTER'
</span><a href="#680" id="680" class="l">680: </a><span class="php-quote">                    WHEN 5 THEN 'BEFORE'
</span><a href="#681" id="681" class="l">681: </a><span class="php-quote">                    WHEN 6 THEN 'AFTER'
</span><a href="#682" id="682" class="l">682: </a><span class="php-quote">                END AS TRIGGER_TYPE,
</span><a href="#683" id="683" class="l">683: </a><span class="php-quote">                CASE RDB\</span><span class="php-var">$TRIGGER_TYPE</span><span class="php-quote">
</span><a href="#684" id="684" class="l">684: </a><span class="php-quote">                    WHEN 1 THEN 'INSERT'
</span><a href="#685" id="685" class="l">685: </a><span class="php-quote">                    WHEN 2 THEN 'INSERT'
</span><a href="#686" id="686" class="l">686: </a><span class="php-quote">                    WHEN 3 THEN 'UPDATE'
</span><a href="#687" id="687" class="l">687: </a><span class="php-quote">                    WHEN 4 THEN 'UPDATE'
</span><a href="#688" id="688" class="l">688: </a><span class="php-quote">                    WHEN 5 THEN 'DELETE'
</span><a href="#689" id="689" class="l">689: </a><span class="php-quote">                    WHEN 6 THEN 'DELETE'
</span><a href="#690" id="690" class="l">690: </a><span class="php-quote">                END AS TRIGGER_EVENT,
</span><a href="#691" id="691" class="l">691: </a><span class="php-quote">                CASE RDB\</span><span class="php-var">$TRIGGER_INACTIVE</span><span class="php-quote">
</span><a href="#692" id="692" class="l">692: </a><span class="php-quote">                    WHEN 1 THEN 'FALSE' ELSE 'TRUE'
</span><a href="#693" id="693" class="l">693: </a><span class="php-quote">                END AS TRIGGER_ENABLED
</span><a href="#694" id="694" class="l">694: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$TRIGGERS</span><span class="php-quote">
</span><a href="#695" id="695" class="l">695: </a><span class="php-quote">            WHERE RDB\</span><span class="php-var">$SYSTEM_FLAG</span><span class="php-quote"> = 0&quot;</span>
<a href="#696" id="696" class="l">696: </a>            . (<span class="php-var">$table</span> === <span class="php-keyword1">NULL</span> ? <span class="php-quote">&quot;;&quot;</span> : <span class="php-quote">&quot; AND RDB\</span><span class="php-var">$RELATION_NAME</span><span class="php-quote"> = UPPER('</span><span class="php-var">$table</span><span class="php-quote">');&quot;</span>)
<a href="#697" id="697" class="l">697: </a>        );
<a href="#698" id="698" class="l">698: </a>        <span class="php-var">$triggers</span> = <span class="php-keyword1">array</span>();
<a href="#699" id="699" class="l">699: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">TRUE</span>)) {
<a href="#700" id="700" class="l">700: </a>            <span class="php-var">$triggers</span>[<span class="php-var">$row</span>[<span class="php-quote">'TRIGGER_NAME'</span>]] = <span class="php-keyword1">array</span>(
<a href="#701" id="701" class="l">701: </a>                <span class="php-quote">'name'</span> =&gt; <span class="php-var">$row</span>[<span class="php-quote">'TRIGGER_NAME'</span>],
<a href="#702" id="702" class="l">702: </a>                <span class="php-quote">'table'</span> =&gt; <span class="php-var">$row</span>[<span class="php-quote">'TABLE_NAME'</span>],
<a href="#703" id="703" class="l">703: </a>                <span class="php-quote">'type'</span> =&gt; <span class="php-keyword2">trim</span>(<span class="php-var">$row</span>[<span class="php-quote">'TRIGGER_TYPE'</span>]),
<a href="#704" id="704" class="l">704: </a>                <span class="php-quote">'event'</span> =&gt; <span class="php-keyword2">trim</span>(<span class="php-var">$row</span>[<span class="php-quote">'TRIGGER_EVENT'</span>]),
<a href="#705" id="705" class="l">705: </a>                <span class="php-quote">'enabled'</span> =&gt; <span class="php-keyword2">trim</span>(<span class="php-var">$row</span>[<span class="php-quote">'TRIGGER_ENABLED'</span>]) === <span class="php-quote">'TRUE'</span>,
<a href="#706" id="706" class="l">706: </a>            );
<a href="#707" id="707" class="l">707: </a>        }
<a href="#708" id="708" class="l">708: </a>        <span class="php-keyword1">return</span> <span class="php-var">$triggers</span>;
<a href="#709" id="709" class="l">709: </a>    }
<a href="#710" id="710" class="l">710: </a>
<a href="#711" id="711" class="l">711: </a>
<a href="#712" id="712" class="l">712: </a>
<a href="#713" id="713" class="l">713: </a>    <span class="php-comment">/**
</span><a href="#714" id="714" class="l">714: </a><span class="php-comment">     * Returns list of triggers for given table.
</span><a href="#715" id="715" class="l">715: </a><span class="php-comment">     * (Only if user has permissions on ALTER TABLE, INSERT/UPDATE/DELETE record in table)
</span><a href="#716" id="716" class="l">716: </a><span class="php-comment">     * @param  string
</span><a href="#717" id="717" class="l">717: </a><span class="php-comment">     * @return array
</span><a href="#718" id="718" class="l">718: </a><span class="php-comment">     */</span>
<a href="#719" id="719" class="l">719: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getTriggers(<span class="php-var">$table</span> = <span class="php-keyword1">NULL</span>)
<a href="#720" id="720" class="l">720: </a>    {
<a href="#721" id="721" class="l">721: </a>        <span class="php-var">$q</span> = <span class="php-quote">&quot;SELECT TRIM(RDB\</span><span class="php-var">$TRIGGER_NAME</span><span class="php-quote">)
</span><a href="#722" id="722" class="l">722: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$TRIGGERS</span><span class="php-quote">
</span><a href="#723" id="723" class="l">723: </a><span class="php-quote">            WHERE RDB\</span><span class="php-var">$SYSTEM_FLAG</span><span class="php-quote"> = 0&quot;</span>;
<a href="#724" id="724" class="l">724: </a>        <span class="php-var">$q</span> .= <span class="php-var">$table</span> === <span class="php-keyword1">NULL</span> ? <span class="php-quote">&quot;;&quot;</span> : <span class="php-quote">&quot; AND RDB\</span><span class="php-var">$RELATION_NAME</span><span class="php-quote"> = UPPER('</span><span class="php-var">$table</span><span class="php-quote">')&quot;</span>;
<a href="#725" id="725" class="l">725: </a>
<a href="#726" id="726" class="l">726: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-var">$q</span>);
<a href="#727" id="727" class="l">727: </a>        <span class="php-var">$triggers</span> = <span class="php-keyword1">array</span>();
<a href="#728" id="728" class="l">728: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">FALSE</span>)) {
<a href="#729" id="729" class="l">729: </a>            <span class="php-var">$triggers</span>[] = <span class="php-var">$row</span>[<span class="php-num">0</span>];
<a href="#730" id="730" class="l">730: </a>        }
<a href="#731" id="731" class="l">731: </a>        <span class="php-keyword1">return</span> <span class="php-var">$triggers</span>;
<a href="#732" id="732" class="l">732: </a>    }
<a href="#733" id="733" class="l">733: </a>
<a href="#734" id="734" class="l">734: </a>
<a href="#735" id="735" class="l">735: </a>
<a href="#736" id="736" class="l">736: </a>    <span class="php-comment">/**
</span><a href="#737" id="737" class="l">737: </a><span class="php-comment">     * Returns metadata from stored procedures and their input and output parameters.
</span><a href="#738" id="738" class="l">738: </a><span class="php-comment">     * @param  string
</span><a href="#739" id="739" class="l">739: </a><span class="php-comment">     * @return array
</span><a href="#740" id="740" class="l">740: </a><span class="php-comment">     */</span>
<a href="#741" id="741" class="l">741: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getProceduresMeta()
<a href="#742" id="742" class="l">742: </a>    {
<a href="#743" id="743" class="l">743: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-quote">&quot;
</span><a href="#744" id="744" class="l">744: </a><span class="php-quote">            SELECT
</span><a href="#745" id="745" class="l">745: </a><span class="php-quote">                TRIM(p.RDB\</span><span class="php-var">$PARAMETER_NAME</span><span class="php-quote">) AS PARAMETER_NAME,
</span><a href="#746" id="746" class="l">746: </a><span class="php-quote">                TRIM(p.RDB\</span><span class="php-var">$PROCEDURE_NAME</span><span class="php-quote">) AS PROCEDURE_NAME,
</span><a href="#747" id="747" class="l">747: </a><span class="php-quote">                CASE p.RDB\</span><span class="php-var">$PARAMETER_TYPE</span><span class="php-quote">
</span><a href="#748" id="748" class="l">748: </a><span class="php-quote">                    WHEN 0 THEN 'INPUT'
</span><a href="#749" id="749" class="l">749: </a><span class="php-quote">                    WHEN 1 THEN 'OUTPUT'
</span><a href="#750" id="750" class="l">750: </a><span class="php-quote">                    ELSE 'UNKNOWN'
</span><a href="#751" id="751" class="l">751: </a><span class="php-quote">                END AS PARAMETER_TYPE,
</span><a href="#752" id="752" class="l">752: </a><span class="php-quote">                CASE f.RDB\</span><span class="php-var">$FIELD_TYPE</span><span class="php-quote">
</span><a href="#753" id="753" class="l">753: </a><span class="php-quote">                    WHEN 261 THEN 'BLOB'
</span><a href="#754" id="754" class="l">754: </a><span class="php-quote">                    WHEN 14 THEN 'CHAR'
</span><a href="#755" id="755" class="l">755: </a><span class="php-quote">                    WHEN 40 THEN 'CSTRING'
</span><a href="#756" id="756" class="l">756: </a><span class="php-quote">                    WHEN 11 THEN 'D_FLOAT'
</span><a href="#757" id="757" class="l">757: </a><span class="php-quote">                    WHEN 27 THEN 'DOUBLE'
</span><a href="#758" id="758" class="l">758: </a><span class="php-quote">                    WHEN 10 THEN 'FLOAT'
</span><a href="#759" id="759" class="l">759: </a><span class="php-quote">                    WHEN 16 THEN 'INT64'
</span><a href="#760" id="760" class="l">760: </a><span class="php-quote">                    WHEN 8 THEN 'INTEGER'
</span><a href="#761" id="761" class="l">761: </a><span class="php-quote">                    WHEN 9 THEN 'QUAD'
</span><a href="#762" id="762" class="l">762: </a><span class="php-quote">                    WHEN 7 THEN 'SMALLINT'
</span><a href="#763" id="763" class="l">763: </a><span class="php-quote">                    WHEN 12 THEN 'DATE'
</span><a href="#764" id="764" class="l">764: </a><span class="php-quote">                    WHEN 13 THEN 'TIME'
</span><a href="#765" id="765" class="l">765: </a><span class="php-quote">                    WHEN 35 THEN 'TIMESTAMP'
</span><a href="#766" id="766" class="l">766: </a><span class="php-quote">                    WHEN 37 THEN 'VARCHAR'
</span><a href="#767" id="767" class="l">767: </a><span class="php-quote">                    ELSE 'UNKNOWN'
</span><a href="#768" id="768" class="l">768: </a><span class="php-quote">                END AS FIELD_TYPE,
</span><a href="#769" id="769" class="l">769: </a><span class="php-quote">                f.RDB\</span><span class="php-var">$FIELD_LENGTH</span><span class="php-quote"> AS FIELD_LENGTH,
</span><a href="#770" id="770" class="l">770: </a><span class="php-quote">                p.RDB\</span><span class="php-var">$PARAMETER_NUMBER</span><span class="php-quote"> AS PARAMETER_NUMBER
</span><a href="#771" id="771" class="l">771: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$PROCEDURE_PARAMETERS</span><span class="php-quote"> p
</span><a href="#772" id="772" class="l">772: </a><span class="php-quote">                LEFT JOIN RDB\</span><span class="php-var">$FIELDS</span><span class="php-quote"> f ON f.RDB\</span><span class="php-var">$FIELD_NAME</span><span class="php-quote"> = p.RDB\</span><span class="php-var">$FIELD_SOURCE</span><span class="php-quote">
</span><a href="#773" id="773" class="l">773: </a><span class="php-quote">            ORDER BY p.RDB\</span><span class="php-var">$PARAMETER_TYPE</span><span class="php-quote">, p.RDB\</span><span class="php-var">$PARAMETER_NUMBER</span><span class="php-quote">;&quot;</span>
<a href="#774" id="774" class="l">774: </a>        );
<a href="#775" id="775" class="l">775: </a>        <span class="php-var">$procedures</span> = <span class="php-keyword1">array</span>();
<a href="#776" id="776" class="l">776: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">TRUE</span>)) {
<a href="#777" id="777" class="l">777: </a>            <span class="php-var">$key</span> = <span class="php-var">$row</span>[<span class="php-quote">'PROCEDURE_NAME'</span>];
<a href="#778" id="778" class="l">778: </a>            <span class="php-var">$io</span> = <span class="php-keyword2">trim</span>(<span class="php-var">$row</span>[<span class="php-quote">'PARAMETER_TYPE'</span>]);
<a href="#779" id="779" class="l">779: </a>            <span class="php-var">$num</span> = <span class="php-var">$row</span>[<span class="php-quote">'PARAMETER_NUMBER'</span>];
<a href="#780" id="780" class="l">780: </a>            <span class="php-var">$procedures</span>[<span class="php-var">$key</span>][<span class="php-quote">'name'</span>] = <span class="php-var">$row</span>[<span class="php-quote">'PROCEDURE_NAME'</span>];
<a href="#781" id="781" class="l">781: </a>            <span class="php-var">$procedures</span>[<span class="php-var">$key</span>][<span class="php-quote">'params'</span>][<span class="php-var">$io</span>][<span class="php-var">$num</span>][<span class="php-quote">'name'</span>] = <span class="php-var">$row</span>[<span class="php-quote">'PARAMETER_NAME'</span>];
<a href="#782" id="782" class="l">782: </a>            <span class="php-var">$procedures</span>[<span class="php-var">$key</span>][<span class="php-quote">'params'</span>][<span class="php-var">$io</span>][<span class="php-var">$num</span>][<span class="php-quote">'type'</span>] = <span class="php-keyword2">trim</span>(<span class="php-var">$row</span>[<span class="php-quote">'FIELD_TYPE'</span>]);
<a href="#783" id="783" class="l">783: </a>            <span class="php-var">$procedures</span>[<span class="php-var">$key</span>][<span class="php-quote">'params'</span>][<span class="php-var">$io</span>][<span class="php-var">$num</span>][<span class="php-quote">'size'</span>] = <span class="php-var">$row</span>[<span class="php-quote">'FIELD_LENGTH'</span>];
<a href="#784" id="784" class="l">784: </a>        }
<a href="#785" id="785" class="l">785: </a>        <span class="php-keyword1">return</span> <span class="php-var">$procedures</span>;
<a href="#786" id="786" class="l">786: </a>    }
<a href="#787" id="787" class="l">787: </a>
<a href="#788" id="788" class="l">788: </a>
<a href="#789" id="789" class="l">789: </a>
<a href="#790" id="790" class="l">790: </a>    <span class="php-comment">/**
</span><a href="#791" id="791" class="l">791: </a><span class="php-comment">     * Returns list of stored procedures.
</span><a href="#792" id="792" class="l">792: </a><span class="php-comment">     * @return array
</span><a href="#793" id="793" class="l">793: </a><span class="php-comment">     */</span>
<a href="#794" id="794" class="l">794: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getProcedures()
<a href="#795" id="795" class="l">795: </a>    {
<a href="#796" id="796" class="l">796: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-quote">&quot;
</span><a href="#797" id="797" class="l">797: </a><span class="php-quote">            SELECT TRIM(RDB\</span><span class="php-var">$PROCEDURE_NAME</span><span class="php-quote">)
</span><a href="#798" id="798" class="l">798: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$PROCEDURES</span><span class="php-quote">;&quot;</span>
<a href="#799" id="799" class="l">799: </a>        );
<a href="#800" id="800" class="l">800: </a>        <span class="php-var">$procedures</span> = <span class="php-keyword1">array</span>();
<a href="#801" id="801" class="l">801: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">FALSE</span>)) {
<a href="#802" id="802" class="l">802: </a>            <span class="php-var">$procedures</span>[] = <span class="php-var">$row</span>[<span class="php-num">0</span>];
<a href="#803" id="803" class="l">803: </a>        }
<a href="#804" id="804" class="l">804: </a>        <span class="php-keyword1">return</span> <span class="php-var">$procedures</span>;
<a href="#805" id="805" class="l">805: </a>    }
<a href="#806" id="806" class="l">806: </a>
<a href="#807" id="807" class="l">807: </a>
<a href="#808" id="808" class="l">808: </a>
<a href="#809" id="809" class="l">809: </a>    <span class="php-comment">/**
</span><a href="#810" id="810" class="l">810: </a><span class="php-comment">     * Returns list of generators.
</span><a href="#811" id="811" class="l">811: </a><span class="php-comment">     * @return array
</span><a href="#812" id="812" class="l">812: </a><span class="php-comment">     */</span>
<a href="#813" id="813" class="l">813: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getGenerators()
<a href="#814" id="814" class="l">814: </a>    {
<a href="#815" id="815" class="l">815: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-quote">&quot;
</span><a href="#816" id="816" class="l">816: </a><span class="php-quote">            SELECT TRIM(RDB\</span><span class="php-var">$GENERATOR_NAME</span><span class="php-quote">)
</span><a href="#817" id="817" class="l">817: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$GENERATORS</span><span class="php-quote">
</span><a href="#818" id="818" class="l">818: </a><span class="php-quote">            WHERE RDB\</span><span class="php-var">$SYSTEM_FLAG</span><span class="php-quote"> = 0;&quot;</span>
<a href="#819" id="819" class="l">819: </a>        );
<a href="#820" id="820" class="l">820: </a>        <span class="php-var">$generators</span> = <span class="php-keyword1">array</span>();
<a href="#821" id="821" class="l">821: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">FALSE</span>)) {
<a href="#822" id="822" class="l">822: </a>            <span class="php-var">$generators</span>[] = <span class="php-var">$row</span>[<span class="php-num">0</span>];
<a href="#823" id="823" class="l">823: </a>        }
<a href="#824" id="824" class="l">824: </a>        <span class="php-keyword1">return</span> <span class="php-var">$generators</span>;
<a href="#825" id="825" class="l">825: </a>    }
<a href="#826" id="826" class="l">826: </a>
<a href="#827" id="827" class="l">827: </a>
<a href="#828" id="828" class="l">828: </a>
<a href="#829" id="829" class="l">829: </a>    <span class="php-comment">/**
</span><a href="#830" id="830" class="l">830: </a><span class="php-comment">     * Returns list of user defined functions (UDF).
</span><a href="#831" id="831" class="l">831: </a><span class="php-comment">     * @return array
</span><a href="#832" id="832" class="l">832: </a><span class="php-comment">     */</span>
<a href="#833" id="833" class="l">833: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getFunctions()
<a href="#834" id="834" class="l">834: </a>    {
<a href="#835" id="835" class="l">835: </a>        <span class="php-var">$res</span> = <span class="php-var">$this</span>-&gt;query(<span class="php-quote">&quot;
</span><a href="#836" id="836" class="l">836: </a><span class="php-quote">            SELECT TRIM(RDB\</span><span class="php-var">$FUNCTION_NAME</span><span class="php-quote">)
</span><a href="#837" id="837" class="l">837: </a><span class="php-quote">            FROM RDB\</span><span class="php-var">$FUNCTIONS</span><span class="php-quote">
</span><a href="#838" id="838" class="l">838: </a><span class="php-quote">            WHERE RDB\</span><span class="php-var">$SYSTEM_FLAG</span><span class="php-quote"> = 0;&quot;</span>
<a href="#839" id="839" class="l">839: </a>        );
<a href="#840" id="840" class="l">840: </a>        <span class="php-var">$functions</span> = <span class="php-keyword1">array</span>();
<a href="#841" id="841" class="l">841: </a>        <span class="php-keyword1">while</span> (<span class="php-var">$row</span> = <span class="php-var">$res</span>-&gt;fetch(<span class="php-keyword1">FALSE</span>)) {
<a href="#842" id="842" class="l">842: </a>            <span class="php-var">$functions</span>[] = <span class="php-var">$row</span>[<span class="php-num">0</span>];
<a href="#843" id="843" class="l">843: </a>        }
<a href="#844" id="844" class="l">844: </a>        <span class="php-keyword1">return</span> <span class="php-var">$functions</span>;
<a href="#845" id="845" class="l">845: </a>    }
<a href="#846" id="846" class="l">846: </a>
<a href="#847" id="847" class="l">847: </a>}
<a href="#848" id="848" class="l">848: </a>
<a href="#849" id="849" class="l">849: </a>
<a href="#850" id="850" class="l">850: </a>
<a href="#851" id="851" class="l">851: </a>
<a href="#852" id="852" class="l">852: </a><span class="php-comment">/**
</span><a href="#853" id="853" class="l">853: </a><span class="php-comment"> * Database procedure exception.
</span><a href="#854" id="854" class="l">854: </a><span class="php-comment"> *
</span><a href="#855" id="855" class="l">855: </a><span class="php-comment"> * @author     Roman Sklenář
</span><a href="#856" id="856" class="l">856: </a><span class="php-comment"> * @copyright  Copyright (c) 2010
</span><a href="#857" id="857" class="l">857: </a><span class="php-comment"> * @package    dibi\drivers
</span><a href="#858" id="858" class="l">858: </a><span class="php-comment"> */</span>
<a href="#859" id="859" class="l">859: </a><span class="php-keyword1">class</span> DibiProcedureException <span class="php-keyword1">extends</span> DibiException
<a href="#860" id="860" class="l">860: </a>{
<a href="#861" id="861" class="l">861: </a>    <span class="php-comment">/** @var string */</span>
<a href="#862" id="862" class="l">862: </a>    <span class="php-keyword1">protected</span> <span class="php-var">$severity</span>;
<a href="#863" id="863" class="l">863: </a>
<a href="#864" id="864" class="l">864: </a>
<a href="#865" id="865" class="l">865: </a>    <span class="php-comment">/**
</span><a href="#866" id="866" class="l">866: </a><span class="php-comment">     * Construct the exception.
</span><a href="#867" id="867" class="l">867: </a><span class="php-comment">     * @param  string  Message describing the exception
</span><a href="#868" id="868" class="l">868: </a><span class="php-comment">     * @param  int     Some code
</span><a href="#869" id="869" class="l">869: </a><span class="php-comment">     * @param  string SQL command
</span><a href="#870" id="870" class="l">870: </a><span class="php-comment">     */</span>
<a href="#871" id="871" class="l">871: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> __construct(<span class="php-var">$message</span> = <span class="php-keyword1">NULL</span>, <span class="php-var">$code</span> = <span class="php-num">0</span>, <span class="php-var">$severity</span> = <span class="php-keyword1">NULL</span>, <span class="php-var">$sql</span> = <span class="php-keyword1">NULL</span>)
<a href="#872" id="872" class="l">872: </a>    {
<a href="#873" id="873" class="l">873: </a>        parent::__construct(<span class="php-var">$message</span>, (int) <span class="php-var">$code</span>, <span class="php-var">$sql</span>);
<a href="#874" id="874" class="l">874: </a>        <span class="php-var">$this</span>-&gt;severity = <span class="php-var">$severity</span>;
<a href="#875" id="875" class="l">875: </a>    }
<a href="#876" id="876" class="l">876: </a>
<a href="#877" id="877" class="l">877: </a>
<a href="#878" id="878" class="l">878: </a>
<a href="#879" id="879" class="l">879: </a>    <span class="php-comment">/**
</span><a href="#880" id="880" class="l">880: </a><span class="php-comment">     * Gets the exception severity.
</span><a href="#881" id="881" class="l">881: </a><span class="php-comment">     * @return string
</span><a href="#882" id="882" class="l">882: </a><span class="php-comment">     */</span>
<a href="#883" id="883" class="l">883: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> getSeverity()
<a href="#884" id="884" class="l">884: </a>    {
<a href="#885" id="885" class="l">885: </a>        <span class="php-var">$this</span>-&gt;severity;
<a href="#886" id="886" class="l">886: </a>    }
<a href="#887" id="887" class="l">887: </a>
<a href="#888" id="888" class="l">888: </a>}
<a href="#889" id="889" class="l">889: </a></code></pre>

	<div id="footer">
		Dibi 2.0.2 API documentation API documentation generated by <a href="http://apigen.org">ApiGen 2.6.1</a>
	</div>
</div>
</div>
</body>
</html>
